Hi!

One way:

A1 = credits
B1 = some letter grade

=A1*IF(B1="",0,LOOKUP(B1,{"A","B","C","D"},{4,3,2, 1}))

Biff

"Don" wrote in message
...
I am trying to make a chart that I can use to figure out grade point
average
(4.0 scale). I will enter the # of credits taken by the student, and then
enter the grade A=4, B=3, C=2, D=1. The credits will be multiplied by the
grade value. Is this possible

I