lisbon_lion67
New Member
- Joined
- Mar 3, 2007
- Messages
- 6
I use excel as my school mark book. This involves needing to convert grades (letters) into numbers and vice versa. I am able to use a vlookup table for the majority of this. However I have found an anomoly when trying to include grades at A-star (A*).
I have included a table like this to show the grade boundaries:
Grade %
A* 90
A 80
B 70
C 60
D 50
E 40
F 30
G 20
U 0
i.e. 90 or above = A*, 80 or above = A, 70 or above = B and so on.
Students are given a target grade. I need to convert this to a number so I can calculate averages, etc. I do this by using a vlookup function (e.g. =VLOOKUP(A2,B2:C10,2)).
This seems to work for all of the grades except A*. For example below are the results when I try to look up the value in the 2nd column. As you will notice both A* and A come out at 80%.
Student Target Grade % Required
Adam A* 80
Alex A 80
Ben B 70
Charlie C 60
David D 50
Edward E 40
Frank F 30
George G 20
Can someone help me with a solution? I've tried various ideas but nothing seems to work!
I have included a table like this to show the grade boundaries:
Grade %
A* 90
A 80
B 70
C 60
D 50
E 40
F 30
G 20
U 0
i.e. 90 or above = A*, 80 or above = A, 70 or above = B and so on.
Students are given a target grade. I need to convert this to a number so I can calculate averages, etc. I do this by using a vlookup function (e.g. =VLOOKUP(A2,B2:C10,2)).
This seems to work for all of the grades except A*. For example below are the results when I try to look up the value in the 2nd column. As you will notice both A* and A come out at 80%.
Student Target Grade % Required
Adam A* 80
Alex A 80
Ben B 70
Charlie C 60
David D 50
Edward E 40
Frank F 30
George G 20
Can someone help me with a solution? I've tried various ideas but nothing seems to work!
