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.
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) |