+ Reply to Thread
Results 1 to 5 of 5

Reverse GPA As Percentage To Calculate A Total Score

  1. #1
    Registered User
    Join Date
    10-20-2011
    Location
    Cluj-Napoca, Romania
    MS-Off Ver
    Excel 2003
    Posts
    3

    Reverse GPA As Percentage To Calculate A Total Score

    Hi there,

    I need help with a formula to calculate the GPA as a percentage from a total score.

    Total Score: 100 points
    GPA percentage from Score Total: 50%
    1 = maximum GPA (best GPA)
    5 = minimum GPA (worst GPA)

    Expected GPA percent values from Total Score must be:
    1 = 50 points
    2 = 40 points
    3 = 30 points
    4 = 20 points
    5 = 10 points

    I put only integer values for the GPA in order to simplify the message but there are also noninteger values between 1 and 5.

    I attach an excel file where I do some test's.

    Many thanks in advance,
    Yours,
    Claudiu Nemes
    Attached Files Attached Files
    Last edited by claudiopolis; 10-21-2011 at 08:52 AM.

  2. #2
    Valued Forum Contributor
    Join Date
    10-13-2010
    Location
    Sunderland, England
    MS-Off Ver
    Excel 2007 (Home) / 2003 (Work)
    Posts
    740

    Re: Reverse GPA As Percentage To Calculate A Total Score

    How about:

    =B16-(A16-1)*10

  3. #3
    Registered User
    Join Date
    10-20-2011
    Location
    Cluj-Napoca, Romania
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Reverse GPA As Percentage To Calculate A Total Score

    Hi brokenbiscuits,

    Many thanks for your reply. It solves somehow the problem if the percentage of the GPA from the Total Score (TS) is no less then 40%. Under 40% last values becomes negative. For instance if GPA represents 30% from the TS for the mark 5 I have -5 points. Actually the GPA percentage is a dynamic variable that could be changed from 0% to 100% according the needs.
    It should work somehow like this:
    if GPA % from TS = 10%
    1 = 10
    2 = 8
    3 = 6
    4 = 4
    5 = 2

    or even better

    1 = 10
    2 = 7.5
    3 = 5
    4 = 2.5
    5 = 0

    Many thanks for your time,
    Yours,
    Claudiopolis

  4. #4
    Valued Forum Contributor
    Join Date
    10-13-2010
    Location
    Sunderland, England
    MS-Off Ver
    Excel 2007 (Home) / 2003 (Work)
    Posts
    740

    Re: Reverse GPA As Percentage To Calculate A Total Score

    =b16-(a16-1)*b16/4

    (or /5, depending on the result you prefer)

    ?
    Last edited by brokenbiscuits; 10-21-2011 at 07:12 AM.

  5. #5
    Registered User
    Join Date
    10-20-2011
    Location
    Cluj-Napoca, Romania
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Reverse GPA As Percentage To Calculate A Total Score

    wow,

    thank you brokenbiscuits. It works exactly as I want. Many thanks, hope I could return this help somehow.

    I have visited Sunderland University some years ago. Great city, great people.

    Many thanks again,
    Yours,
    Claudiu

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1