=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