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!

Attached Images

SOLOM Screencap.JPG (85.3 KB, 20 views)