August 10, 2017
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)|
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.
June 25, 2016
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.