Results 1 to 4 of 4

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. #1
    New Member
    Join Date
    Mar 2002
    Posts
    2

    Default

    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. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654

    Default

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

  3. #3
    MrExcel MVP Al Chara's Avatar
    Join Date
    Feb 2002
    Location
    Newark, Delaware
    Posts
    1,701

    Default

    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. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654

    Default

    *
    CourseLetter_GradeGradeCredit_Hrs
    EngA4.03
    MathB3.03
    ScienceB3.03
    HistoryA4.03
    GPA3.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 ]

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com