Assigning Scores to Grades
Posted by SJC on December 14, 2000 4:14 PM
I have a list of scores (772, 225, 316, 452, 58, etc.) to which I want to assign grades (A, B, C, D, E, ..., Z, etc.). If the score is >=500, the grade is A. If the score is between 490 and 499, the grade is B. If the score is between 480 and 489, the grade is C. This goes on all the way through score zero. The problem is there are too many grades so I don't want to enter a lengthy IF statement (even if that were possible). Can you help?
Posted by marbel on December 14, 2000 4:24 PM
----
The way I would do it (not necessarily the most efficient) is to create a table with all possible grades in a column (put 0 in cell a1, 1 in cell a2, highlight both and autofill to your highest possible grade) and then the corresponding letter grade (again, not tough with copy and paste or ctr+enter to fill a range with the same value). Then, refer to the table with VLOOKUP to return the corresponding letter grade.
Let me know if that doesn't work for you or if you need additional info on my technique.
mb
Posted by SJC on December 14, 2000 4:38 PM
Thanks MB. Unfortunately, the scores are not discrete numbers so VLOOKUP isn't going to do the trick effectively.
Posted by marbel on December 14, 2000 4:41 PM
Even if Range_lookup = TRUE?
Posted by SJC on December 14, 2000 4:45 PM
What's Range_lookup?
Posted by marbel on December 14, 2000 4:56 PM
It's the last argument in the VLOOKUP formula. If you type "=vlookup" and then hit the "=" next to the formula bar, it helps walk through the arguments of a formula. Helpful in these multiple argument formulas.
eg. =VLOOKUP(E92,table,2,TRUE)
Posted by SJC on December 14, 2000 5:32 PM
It worked. Many thanks!
