answersLogoWhite

0


Best Answer
  1. Put total hours taken in cell A1.
  2. Put the total of all grade points in B1.
  3. Enter the following formula in C1: =B1/A1.
  4. Format C1 to display two decimal points.
  5. Observe your GPA in C1.
User Avatar

Wiki User

14y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: What is the formula to find a GPA in Microsoft Excel?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What GPA would I have if you have 3 A's and 2 B's?

There's no single GPA formula, but if there is no weighting due to course hours or other factors, that should be a 3.6 GPA. See the links for more info, and you should also find out just how your place of education calculates GPAs.


How can you display a list of marketing majors with a GPA of 3.0 or greater from an excel table with records for 300 students?

uncategorized


How can you find a chart that shows how to calculate GPA for a University?

Are you sure you mean a chart? A GPA is calculated based on a formula, there is no chart involved. Basically every letter grade has a corresponding value from 0 to 4. You multiple that number by the course hours. Sum them all up and divide it by the total number of course hours. You can find a more detailed explanation and calculate your GPA on certain websites.


What GPA do you need to get into ODU?

How many centimeters are in an inch? Answer this and you will find enlightenment.


What is GPA test?

It is a test where you find out your GPA (Grade Point Average)


How do you find the cumlative GPA on a 4 year degree?

It is indicated on the students official transcript. If will give the semester by semester GPA and the cumulative GPA.


How do you find your GPA from 1978?

Contact your high school.


What is the average GPA of Williams College?

go to www.collegeboard.com you will find all the information you need there


Where can one find more information about calculating your GPA?

One can find information about calculating his Grade Point Average on sites like WikiHow or PossibilityU. One can also ask his college to calculate his GPA.


What is a 78 average GPA?

No. A 79 average is 2.4 GPA. Heres a list of all the Grade point averages. 0%-59% => 0 GPA 60% => 0.7 GPA 61% => 0.8 GPA 62% => 0.8 GPA 63% => 0.9 GPA 64% => 1.0 GPA 65% => 1.0 GPA 66% => 1.1 GPA 67% => 1.2 GPA 68% => 1.3 GPA 69% => 1.4 GPA 70% => 1.5 GPA 71% => 1.6 GPA 72% => 1.7 GPA 73% => 1.8 GPA 74% => 1.9 GPA 75% => 2.0 GPA 76% => 2.1 GPA 77% => 2.2 GPA 78% => 2.3 GPA 79% => 2.4 GPA 80% => 2.5 GPA 81% => 2.7 GPA 82% => 2.8 GPA 83% => 2.9 GPA 84% => 3.0 GPA 85% => 3.0 GPA 86% => 3.1 GPA 87% => 3.2 GPA 88% => 3.3 GPA 89% => 3.4 GPA 90% => 3.5 GPA 91% => 3.5 GPA 92% => 3.6 GPA 93% => 3.7 GPA 94% => 3.8 GPA 95% => 3.9 GPA 96% => 3.9 GPA 97% => 4.0 GPA 98% => 4.0 GPA 99% => 4.0 GPA 100% => 4.0 GPA http://qna.educouncil.org/Tests_and_Results/nZxyNXyyynN.html


What GPA is 86.6 grade?

It all depends on the course; whether the course is standardized or not and it's intended difficulty. As a general rule of thumb, 80-85% is a B+ which constitutes 3.25. 86-90% is usually A- which is 3.75


What would your GPA be if you got 1 a and 3 c and 1 b in regular classes?

Let A = 4 Let B = 3 Let C = 2 Class Score = A + B + (C * 3) Class Score = 4 + 3 + 6 Class Score = 13 Number of classes = 5 GPA = Class Score / Number of classes GPA = 13 / 5 GPA = 2.6 Your school may use a different scale for each class, but this formula will work, just find out what A/B/C/D equals at your school.