IF Statement With Multiple AND/ORs (Excel 2002)

Topic

New Reply

Hi All, I am trying to do a nested IF statement but get lost because I need to do AND/OR multiple times. I did a simple chart in the attached file that explains the issues. Is there a way to get one IF statement that will look at Col A or A & B, or A & B & C…?

TIA

Reply | Quote

Replies

Try this formula in D4, then fill down:

=IF(LOWER(A4)="red",0,IF(LOWER(LEFT(A4,5))="green",IF(OR(B4>=15,LOWER(C4)="yes"),150,0),""))

I assumed that you want the formula to return a blank if A contains neither red, green or green-late, and that you want it to return 0 if B is less than 15 and C is not “yes”.

Reply | Quote

Hans, the formula works perfectly – and now that I see how you did it, it makes perfect sense. Thanks much!!

Reply | Quote