Hi confused teacher,

One way would be to put the numbers 1 to 100 in column A
and in column B put the corresponding grade then use a
VLOOKUP formula to access it.
You could hide the lookup table or put it in a separate worksheet.

HTH
Martin