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