Thread: help with an if and and statement formula

Hi Aaron

Try this:

=IF(AND(B6<=D6,H6>=0.9),"Yes","No")

Notes:
1) You can't have B6<=D6 and B6>=D6 giving different results. What happens if B6=D6? Do you want Yes or No? Similarly H6<=0.9 or H6>=0.9. i.e. Correct logic should be H6>=0.9 then Yes or H6<0.9 then No (for example). You may need to change my formula above to account for this.
2) In my formula, the only time that you get a Yes is in your first condition. The rest of the time, the first condition isn't true (i.e. B6>D6 or H6<0.9), so you will get No. Therefore there is no need to check for these individually. I assume I have correctly understood your requirement.

Hope this helps.

Best regards, Rob.