If Credits are in A2, Grade (A,B,C or D) in B2 then in C2:

=A5*(69-CODE(UPPER(B5)))

UPPER allows for entry of lower case codes.

HTH

"Don" wrote:

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