need help calculating based on a given grade.

You could nest a number of IF statements comparing the values, however the K.I.S.S. principle is your friend with Excel. If you are concerned with the location for the values, perhaps put them on a different worksheet and reference the new location in the vlookup formula.

http://en.wikipedia.org/wiki/KISS_principle