Formula involving a letter that has to have a numeric value

[Don]

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

 

[Toppers]

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

 

[Toppers]

oops ..should be ...

=A2*(69-CODE(UPPER(B2)))

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

 

[Biff]

Hi!

One way:

A1 = credits
B1 = some letter grade

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

Biff

 

[Pete_UK]

I'm not sure what you are asking. Do you want to convert the grade
letters to a number that can then be used to multiply the credits? If
so, try this:

=SEARCH(A1,"DCBA")

this will return 4 if "A" is in A1, down to 1 for "D". As an
alternative, the following will do exactly the same:

=69-CODE(A1)


Hope this helps.

Pete