I need a formula that will return the score if criteria is met. Scorecard grid:
SCORE GRID
1 = 79% and below
2 = 80% to 84%
3 = 85% to 89%
3.5 = 90% to 94%
4 = 95% to 97%
4.5 = 98% to 99%
5 = 100% and above
How can I have it to give me a score of "3.5" if the actual grade achieved is 93% which is in between "90% to 94%"?
I appreciate any assistance.
Thank you,
SJV9
SCORE GRID
1 = 79% and below
2 = 80% to 84%
3 = 85% to 89%
3.5 = 90% to 94%
4 = 95% to 97%
4.5 = 98% to 99%
5 = 100% and above
How can I have it to give me a score of "3.5" if the actual grade achieved is 93% which is in between "90% to 94%"?
I appreciate any assistance.
Thank you,
SJV9
