IF Function Multiple Criteria

CorieW

New Member
Joined
Jan 1, 2021
Messages
2
Office Version
  1. 365
Platform
  1. Windows
  2. Web
Hello,

I am at my wits end with this I have been using the IF Function that has multiple Criteria.. Any Help would be greatly appreciated.

=IF(B29<10,"Fail",IF(B29=10<>112,"Pass",IF(B29=12<>14,"Good",IF(B29=14<>16,"Very Good",IF(B29>16,"Excellent","NA")))))

and I am not getting the results I need please see screen shot.


Fail (when the average is below 10)
Pass (when the average is between 10 and 12)
Good (when the average is between 12 and 14)
Very Good (when the average is between 14 and 16)
Excellent (when the average is beyond 16)
NA (other than mentioned above)

1609698954750.png
 

Attachments

  • 1609698908159.png
    1609698908159.png
    19.8 KB · Views: 3

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.
Hi & welcome to MrExcel.
How about
Excel Formula:
=IF(B29<10,"Fail",IF(B29<12,"Pass",IF(B29<14,"Good",IF(B29<16,"Very Good","Excellent"))))
 
Upvote 0
Solution
Hi & welcome to MrExcel.
How about
Excel Formula:
=IF(B29<10,"Fail",IF(B29<12,"Pass",IF(B29<14,"Good",IF(B29<16,"Very Good","Excellent"))))
Thank you for the welcome and the assistance... this worked I really appreciate it.. I marked it off :D
 
Upvote 0
Just for the fun of it, another way, assuming no -ve values
Excel Formula:
=INDEX({"Fail","Pass","Good","Very Good","Excellent"},MATCH(C5,{0,10,12,14,16},1))
 
Upvote 0
Glad we could help & thanks for the feedback.
 
Upvote 0

Forum statistics

Threads
1,213,561
Messages
6,114,312
Members
448,564
Latest member
ED38

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top