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.


--
scabbage
------------------------------------------------------------------------
scabbage's Profile: http://www.excelforum.com/member.php...o&userid=28275
View this thread: http://www.excelforum.com/showthread...hreadid=478416

Example here

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

--
Regards,

Peo Sjoblom

(No private emails please)


"scabbage" wrote in
message ...

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.


--
scabbage
------------------------------------------------------------------------
scabbage's Profile:
http://www.excelforum.com/member.php...o&userid=28275
View this thread: http://www.excelforum.com/showthread...hreadid=478416

On Fri, 21 Oct 2005 20:55:22 -0500, scabbage
wrote:


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

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


--
scabbage
------------------------------------------------------------------------
scabbage's Profile: http://www.excelforum.com/member.php...o&userid=28275
View this thread: http://www.excelforum.com/showthread...hreadid=478416