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
Bookmarks