I think it might be useful if you told us all the possible grades there are
(is the an A-, a B+, an E anything, etc.) and the point values for them
(there doesn't seem to be enough numbers available if you start A+ at 4
unless duplicate values exist for different grades or unless negative values
exist).

--
Rick (MVP - Excel)


"excelguy" wrote in message
...
I have a list of students with grades ranging from A+ to F. How can I make
Excel calculate an A+ to equal 4 points and multiply it by the number of
credits taken. For example:

Name Grade Credits Total
John Smith A+ 3 12