You will probably have to set up a lookup table, and use the VLOOKUP function.

A 1
B 2
C 3
D 4
E 5


"BlackBond" wrote:

This is very simple, but I can't find a variable assignment function. How
can I assign a number value to a letter grade presented in an Excel table?

Thanks