![]() |
#1
|
|||
|
|||
![]() Hi, I searched a bit and didn't see this question, so here goes: I want to create a nested IF formula that associates a raw score/number with a specific proficiency level; that is, if a score is 23, it should be assigned a proficiency level of 5. If the score is 22, it should be assigned a proficiency level of 4, and so on. Here is the formula I used: =IF(K14>10,"1",IF(K14>15,"2",IF(K14>19,"3",IF(K14> 23,"4",IF(K14<26,"5"))))) No go. So I reversed it: =IF(K14>26,"5",IF(K14>23,"4",IF(K14>19,"3",IF(K14> 15,"2",IF(K14<10,"1"))))) Still no go. I attached a screen shot of the page. Any thoughts on how to create a cascading or nested IF (or maybe another) statement? The green shaded areas include the overall score (tallied from each column using COUNTA) and the Proficiency level. Thanks! |
Tags |
nested |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
nested if and averageA | windseaker | Excel | 0 | 08-14-2015 04:13 PM |
![]() |
wentworth16238 | Excel | 5 | 06-14-2015 12:59 PM |
Nested Countif Function | bdavidson22 | Excel | 0 | 12-19-2014 12:36 PM |
Nested Vlookup Help | asluder2000 | Excel | 2 | 11-14-2014 11:00 PM |
![]() |
JimS378 | Excel | 7 | 05-03-2011 08:20 PM |