Hello,

I am trying to build a spreadsheet that calculates a GPA.

Basically what I have is the letter grades in the C column and the value of the letter grades in D column. Instead of entering the letter grade and then the value of the letter grade, I want excel to know what the value of each letter grade is and display it accordingly in the next column.

I can figure out how to make it work with one letter:
=IF(($C2="A"),"4.0","")

I want to add in

=IF((C2="A-"),"3.7","")

along with

=IF((C2="B+"),"3.3","")

etc.

Is the IF function the wrong function to do this with? How could I go about doing something like this?

Thanks a lot for your help
Sean