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