In this article, you’ll learn how to find a percentage of a given data in Microsoft Excel. Microsoft Excel does not provide a direct function to calculate the percentage but instead using formulas it lets you calculate the percentage. Now let’s see how to find it.
How to calculate percentage in Microsoft Excel?
Let us consider a student mark sheet.
To calculate a percentage first you need to find the total. So we use the SUM function to calculate the total of the marks and the marks obtained by the student.
Select the SUM function to find the total.
Enter the range of the cells which contain the marks that should be summed up. Click on OK to proceed.
Then you get the total of the marks of all the subjects. Similarly, calculate the sum of the marks obtained by the student.
Now let’s proceed to how to find the percentage.
To find the percentage of the total marks you need the total which is then divided by the total marks in this case and then multiplied by 100.
So go to the formula bar enter the formula, in this case, =SUM(F2:F9)/800*100 to calculate the highest percentage and similarly =SUM(G2:G9)/800*100 to find the percentage of the marks obtained by the student.
Here we use previously calculated sum i.e, total instead of using the SUM function again.
Similarly use the formula =G11/800*100 to calculate the percentage obtained by the student. Here we use G11 which is the total scored by the student which is divided by the total highest mark i.e, 800 which is in the cell F11, and then multiplied by 100.
This is how you calculate the percentage in Microsoft Excel.