try to convert letter grades into GPA grade points

S

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.
 
R

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top