#1




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! 
#2




Lots of ways to skin that cat. Here's one.
On the left is the lookup table with the lower bound of your intervals under Score and the corresponding Level to their right. To the right, enter a score into the cell in E2 and it returns the level in E3. This is the formula: =VLOOKUP(E2,$A$2:$B$6,2) What that does is look up the value of E2 in $A$2:$B$6 that is either equal to or lower and closest to it. It then returns the corresponding value it finds in Column 2 of that range. 
#3




Nested If
Thanks, gebobs,
Problem solved. Your solution worked perfectly. I really appreciate your help. Best, DeVere Last edited by TDWolsey; 01062016 at 11:33 PM. Reason: add detail. 
Tags 
nested 
Thread Tools  
Display Modes  

Similar Threads  
Thread  Thread Starter  Forum  Replies  Last Post 
nested if and averageA  windseaker  Excel  0  08142015 04:13 PM 
using if and nested vlookup  wentworth16238  Excel  5  06142015 12:59 PM 
Nested Countif Function  bdavidson22  Excel  0  12192014 12:36 PM 
Nested Vlookup Help  asluder2000  Excel  2  11142014 11:00 PM 
Nested IFs  JimS378  Excel  7  05032011 08:20 PM 