help with an if and and statement formula

[Aaron Baker]

need help. dont know if excel can do this but this is what i need.

if b6 ≤ d6 and h6 ≥ 0.90 then yes
if b6 ≥ d6 and h6 ≥ 0.90 then no
if b6 ≥ d6 and h6 ≤ 0.90 then no

can this be done in one formula?

ps

ive never got past basic math in excel. way over my head lol

aaron

[rscsmith]

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.