Converting a students grade & credit hours to current GPA

[tstrickl]

Can someone please help me figure out on excel how to figure this? I have
students letter grade, credit hours for each class, on our grading scale to
calculate the GPA.

Thanks.
Terri Strickland

 

[joel]

You can convert the letters to number using match

=MATCH(F1,{"F","D","C","B","A"},0)-1


Do you have grades using A+ and A-

Then use lookup

=MATCH(F1,{"F","D","C-","C","C+","B-","B","B+","A-","A","A+";0,.5,1,1.5,1.5,2.0,2.5,2.5,3.0,3.5,3.5,4.0,4.5})-