Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Michigan, USA
    Posts
    408
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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
    <font face="Comic Sans MS"><big><font color=4682b4>Sherry</font color=4682b4></big></font face=comic>

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    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. #3
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Michigan, USA
    Posts
    408
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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!!
    <font face="Comic Sans MS"><big><font color=4682b4>Sherry</font color=4682b4></big></font face=comic>

Posting Permissions

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