try to convert letter grades into GPA grade points

[scabbage]

Hi, guys,

I am trying to create a spreadsheet that can calculate my GPA. I have
column B be the number of credit and column C be the letter grade I can
enter from F to A+. Now, I want column D to be the grade point, which is
converted from column C. For example, when I enter A in C1, I want D1 to
be filled with 4 automatically; when I enter B+ in C2, D2 should be
3.33, and so forth. How can I do this? I tried using LOOKUP function
but no luck. Any idea? Thanks.

 

[Peo Sjoblom]

Example here

http://www.contextures.com/xlFunctions02.html#Range

--
Regards,

Peo Sjoblom

(No private emails please)

 

[Ron Rosenfeld]

Hi, guys,

I am trying to create a spreadsheet that can calculate my GPA. I have
column B be the number of credit and column C be the letter grade I can
enter from F to A+. Now, I want column D to be the grade point, which is
converted from column C. For example, when I enter A in C1, I want D1 to
be filled with 4 automatically; when I enter B+ in C2, D2 should be
3.33, and so forth. How can I do this? I tried using LOOKUP function
but no luck. Any idea? Thanks.

If you set up a table someplace on your worksheet that has the letter grades in
one column, and the corresponding amount of credits in the column just to the
left, you can then use VLOOKUP.

Something like:

D1: =VLOOKUP(C1,tbl,2,false)




--ron

 

[scabbage]

Peo and Ron, thanks a lot. Now everything works. Great job