Quote Originally Posted by FDibbins View Post
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

Quote Originally Posted by Jonmo1 View Post
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.