Gpa formula

This is a discussion on Gpa formula within the Excel Questions forums, part of the Question Forums category; How do I calculate gpa in one formula on the 4.0 scale? I have the doc set up so that ...

1. 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 ]

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

3. 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 ]

4. ******>*
 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...

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 ]

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•