# Thread: How to calculate GPA in Excel worksheet

1. Member
Join Date
Feb 2008
Posts
1,337

## How to calculate GPA in Excel worksheet

I have a small database of students maintained in Excel. I want to calculate their Grade Point Average. But this is very time consuming for 1500+ students. Is there any possibility to achieve this with either some simple formula or some calculator available for calculating the Grade Point Average (GPA)?

2. Member
Join Date
Sep 2005
Posts
1,306

## Re: How to calculate GPA in Excel worksheet

I don't know how to calculate GPA in Excel but here is an online calculator: http://www.usu.edu/advising/gpa/File...or%20Excel.htm. You just need to enter data in the white boxes. The calculator which will do the operations and give you the result. The best part is that you can even print this result.

3. Member
Join Date
May 2008
Posts
979

## Re: How to calculate GPA in Excel worksheet

You can calculate the GPA in Excel and it is quiet simple. The formula for this is:
Code:
`=SUM(Grade*Credit_Hrs)/SUM(Credit_Hrs)`
This formula will automatically calculate the grade point average and give you the result. This formula is very helpful if you have a larger number of records (which is what in your case) and have less time or want to achieve it very faster.

4. Member
Join Date
May 2008
Posts
4,834

## Re: How to calculate GPA in Excel worksheet

The basic idea for calculating the grade point is: (Grade in Class) x (Credits in class)

Now, to calculate the grade point average, add all your grade points and then divide this value by the number of credits you took.

For example, if the Class A is having 4 credits and got 5.5 grade, then the grade point is 4 x 5.5 = 22. If the Class B is having 6 credits and got 3 grade, then the grade point is 6 x 3 = 18. Now the GPA would be (18+22)/(4+6)=4

#### Posting Permissions

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