Notifications
Clear all
Topic starter
Hi
How do I create a formula that matches this table?
| Performance Tier | Pre-Test Score (Score prior to interval of instruction) | Growth Target (Add to Score) | |
| Tier A | >=0 | <=13 | 5 |
| Tier B | >=14 | <=29 | 7 |
| Tier C | >=30 | <=47 | 11 |
| Tier D | >=48 | <=65 | 9 |
| Tier E | >=66 | <=81 | 7 |
| Tier F | >=82 | <=94 | 5 |
I am able to create an If And formula for tier A; however, once I instruct it to add 5 I am not able to add any more tier criterias.
Posted : 10/08/2017 10:59 pm
Hi Rona
I would normally use a VLOOKUP in a situation like this.
Since you wanted an IF formula, I have attached a sample containing both VLOOKUP and IF formulas.
Here I am making an assumption that the minimum Tier A pre-test score is 0 and Tier F pre-test score is 82 and above (no maximum).
Hope this helps.
Sunny
Posted : 11/08/2017 12:03 am
Topic starter
Thank you so very much SunnyKow! This works!
Posted : 12/08/2017 1:14 pm
