"A+" convert to "4," "A-" to "3.7" etc...

  • Thread starter Thread starter Kevin Stone
  • Start date Start date
K

Kevin Stone

I'm doing a GPA chart and want to have the letter grades entered in one cell
and have the corresponding number in the cell beside it... I'm not asking the
right question so I'm not getting the right answer :-).

Kevin
 
Kevin

Look up "IF worksheet function" in help and it gives an example of exactly
what you are looking for. ( in XL2K)

Mike Rogers
 
Hi Kevin,

Probably the simplest approach is to use VLOOKUP. Create a two column table
with the letter grades in the first column and the numeric equivalents in
the second:

A+ 4.33
A 4.00
A- 3.67

and so on. Assume these are in the range A1:B15 and you want to enter a
letter grade in cell D1, the formula in E1 would be
=VLOOKUP(D1,$A$1:$B$15,2,False)
This formula could be copied down column E as far as necessary.
You can make it shorter by naming the cells A1:B15, G and removing FALSE.
=VLOOKUP(D1,G,2)

Cheers,
Shane Devenshire
 
Hi


Like this:
=CHOOSE(MATCH(A1,{"A";"B";"C";"D";"E"},0),5,4,3,2,1)
(You can match up to 29 different values with this formula)
 
Back
Top