Re: Glitched formula? IF statement does not work because of a formula in a reference cell
Originally Posted by FDibbins
Hi and welcome to the forum
Try this shorter version...
=if(OR(A1>21,A2>3),"NO","YES")
Also, test to see if the formula is returning exactly 21 or 3. It may be returning 2.99, formatted to look like 3 etc
edit: or yes, text, like jonmo suggests
Thanks for the less convoluted formula
Originally Posted by Jonmo1
Post the formulas in A1 and A2, they are probably not returning real numbers, but "Numbers stored as text"
Thanks! This was the problem. My formula in A2 was returning a number as text. I took the quotations off the value_if_true part of the formula and it works perfectly now.
Bookmarks