Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change a letter grade to a numerica GPA
I want to type in a letter grade, like A+, A, A- and have excel change it to
it's gpa, like 4.33 for A+. I can do it when I use IF, but I can only use it 7 times and I need to do it 12 times Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change a letter grade to a numerica GPA
=VLOOKUP(A1,{"A+",4.33;"A",3.8;"A-",3.6;"B",3.2;"C",2.7;"D",9},2,FALSE)
adjust the values to suit -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Bogazetti" wrote in message ... I want to type in a letter grade, like A+, A, A- and have excel change it to it's gpa, like 4.33 for A+. I can do it when I use IF, but I can only use it 7 times and I need to do it 12 times Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change a letter grade to a numerica GPA
You can create a datalist and have one of the lookup functions return the
appropriate GPA. Check out this web page of Debra Dalgleish: http://www.contextures.com/xlFunctions02.html -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Bogazetti" wrote in message ... I want to type in a letter grade, like A+, A, A- and have excel change it to it's gpa, like 4.33 for A+. I can do it when I use IF, but I can only use it 7 times and I need to do it 12 times Thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change a letter grade to a numerica GPA
Look at VLOOKUP as an option.
=VLOOKUP(LetterGrade,GPAtable,2,0) where lettergrade = A+ etc GPATable is named range (say columns A & B) containing letter grade & corresponding GPA. A+ 4.33 A ??? HTH "Bogazetti" wrote: I want to type in a letter grade, like A+, A, A- and have excel change it to it's gpa, like 4.33 for A+. I can do it when I use IF, but I can only use it 7 times and I need to do it 12 times Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change a letter to a number in an excel spreadsheet? | Excel Worksheet Functions | |||
Change value in cell | Excel Discussion (Misc queries) | |||
Changing a value to a letter | Excel Worksheet Functions | |||
Grade Percentage into letter grade | Excel Discussion (Misc queries) | |||
try to convert letter grades into GPA grade points | Excel Worksheet Functions |