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

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

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

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