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

Make a chart of grades and points

A+ 4
A 3
B 2
C 1

Then in grand total =C2*VLOOKUP(B2,TABLE,2,0)

where table is the range eyou entered your chart in.

"excelguy" wrote:

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

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