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.