John, the IF function gave me a #REF!Here's how to hide those errors with some help from theWhile applying a formula that results into an excel defined errors (#NA, #VALUE, #NAME etc) are called excel formula errors These errors are caught by excel and printed on the sheets Reasons of these errors can be, unavailable values, incorrect type of arguments, division by 0 etc They are easy to catch and fix Re IFS @choongko Then your Excel
Hi I M Having Trouble Creating An Ifs Statement In A Table I Keep Getting A Name Error The Same Syntax Works For Me In A Normal If Statement Is Ifs Just Not