Gpa formula

[psychogata]

How do I calculate gpa in one formula on the 4.0 scale? I have the doc set up so that I have a list of classes with their grades in one collumn and the numerical equivalents in the next collumn. Can anyone help me? Thanks!

Example:
Assume each class = 3 hours credit


Eng A 4.0
Math B 3.0
Science B 3.0
History A 4.0

Gpa ???


[ This Message was edited by: psychogata on 2002-04-03 09:33 ]

[ This Message was edited by: psychogata on 2002-04-03 09:34 ]

[ This Message was edited by: psychogata on 2002-04-03 09:36 ]

[Mark W.]

Please provide a small amount of sample data and indicate the expected result.

[Al Chara]

If all classes are 3 credits and the grades are in cells C1:C4, then use the following formula:

=SUM(C1:C4)/COUNT(C1:C4)

_________________
Hope this helps.
Kind regards, Al.

[ This Message was edited by: Al Chara on 2002-04-03 10:06 ]

[Mark W.]

*

Course	Letter_Grade	Grade	Credit_Hrs
Eng	A	4.0	3
Math	B	3.0	3
Science	B	3.0	3
History	A	4.0	3
GPA		3.5

The weighted GPA formula used for this result is...

{=SUM(Grade*Credit_Hrs)/SUM(Credit_Hrs)}

Note: This is an array formula which must be entered using the Control+Shift+Enter key combination. The outermost braces, { }, are not entered by you -- they're supplied by Excel in recognition of a properly entered array formula.


[ This Message was edited by: Mark W. on 2002-04-03 09:57 ]