# Thread: IF Statement With Multiple AND/ORs (Excel 2002)

1. ## IF Statement With Multiple AND/ORs (Excel 2002)

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

2. ## Re: IF Statement With Multiple AND/ORs (Excel 2002)

Try this formula in D4, then fill down:
<code>
=IF(LOWER(A4)="red",0,IF(LOWER(LEFT(A4,5))="green" ,IF(OR(B4>=15,LOWER(C4)="yes"),150,0),""))
</code>
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".

3. ## Re: IF Statement With Multiple AND/ORs (Excel 2002)

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

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•