Glitched formula? IF statement does not work because of a formula in a reference cell

Hi all,

I'm trying to create a formula that will return the following:
If A1 > 21
OR
If A2 > 3
Then return the value "No"
Any other configuration would return as "Yes"

The formula I've created is:
=IF(A1>21,"No",IF(A2>3,"No","Yes"))

This works just fine if the values in A1 and A2 are entered by hand or a simple calculation formula (ie. =1*20, etc.). However in my spreadsheet A2 is calculated by another IF statement. For some reason, the formula I've worked out above does not work when the value in A2 is the product of an IF statement...

Any ideas on what my problem is?

I'm using the Mac version of Excel 2011

Post the formulas in A1 and A2, they are probably not returning real numbers, but "Numbers stored as text"

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.

You're welcome.