Change a letter grade to a numerica GPA

[Guest]

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

 

[Bob Phillips]

=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)

 

[RagDyer]

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

 

[Guest]

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