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

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

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

Kevin

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

Mike Rogers

"Kevin Stone" wrote:

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

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

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



"Kevin Stone" <Kevin wrote in message
...
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

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

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)

--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )


"Kevin Stone" <Kevin wrote in message
...
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