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

[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

 

[Mike Rogers]

Kevin

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

Mike Rogers

 

[Shane Devenshire]

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

 

[Arvi Laanemets]

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)