Share via

Excel if formula with multiple conditions and an exception

Anonymous
2015-10-02T21:40:53+00:00

Ok so I have a working formula I'm trying to add on to, =IF(F23="","",IF(F23<100,"NI",IF(F23<115,"SUC",IF(F23<125,"SUP","EXC")))) this formula rates the cell depending on the value in cell F23. However I'm trying to add an exception to this formula to say SUC if F25 <40 and F23 is between 90-100. I'm not sure if this is possible but if anyone has a solution or idea as to how to fix my problem it would be very appreciated!  Thanks in advance!

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Anonymous
    2015-10-02T23:48:24+00:00

    Perhaps this:

     =IF(F23="","",IF(F23<90,"NI",   IF(F23<100,IF(F25<40,"SUC","NI"),

                IF(F23<115,"SUC",IF(F23<125,"SUP","EXC")))))

    0 comments

3 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Ashish Mathur 101K Reputation points Volunteer Moderator
    2015-10-02T23:31:23+00:00

    Hi,

    The formula in cell G23 is

    =IF(F23="","",VLOOKUP(F23,$A$2:$C$6,3,1))

    Here's a screenshot

    0 comments
  2. Anonymous
    2015-10-03T01:17:20+00:00

    Thank you both very much for the help.  This worked like a charm!

    0 comments
  3. Ashish Mathur 101K Reputation points Volunteer Moderator
    2015-10-03T01:35:11+00:00

    You are welcome.  If my reply helped, please mark it as Answer.

    0 comments