| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
try to convert letter grades into GPA grade points
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| hOW CAN I CONVERT NUMERICAL POINTS INTO A LETTER GRADE(SCHOOL) | Excel Worksheet Functions | |||
| How do I convert a given number into a letter? | Excel Worksheet Functions | |||
| students grades, formulae to calculate what grade is needed based. | Excel Worksheet Functions | |||
| Convert Text (letter) To Number Excel | Excel Worksheet Functions | |||
| Converting Letter Grades to Numeric | Excel Worksheet Functions | |||
Threaded Mode
