Nested IF
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!
|