Converting Letter Grade to Numerical Value
I am using VLOOKUP to convert letter grades to numerical grades. I need to
avoid generating #N/A and just have a blank cell when a cell does not contain
a letter grade; e.g.
Letter Grade Column Returned Numercial Grade
A 1
B 2
(At the moment using VLOOKUP
generates #N/A
E 5
Many thanks
|