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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kevin Stone - 03 Feb 2008 05:16 GMT

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

Reply to this Message

Mike Rogers - 03 Feb 2008 05:40 GMT

Kevin

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

Mike Rogers

> 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

Reply to this Message

Shane Devenshire - 03 Feb 2008 06:20 GMT

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

> I'm doing a GPA chart and want to have the letter grades entered in one
> cell
[quoted text clipped - 3 lines]
>
> Kevin

Reply to this Message

Arvi Laanemets - 04 Feb 2008 06:29 GMT

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)

Signature

Arvi Laanemets
( My real mail address: arvi.laanemets<at>tarkon.ee )

> I'm doing a GPA chart and want to have the letter grades entered in one
> cell
[quoted text clipped - 3 lines]
>
> Kevin

Reply to this Message