Formula for percentage
Back to grade 4 arithmetic, here’s the formula for calculating a basic percentage.
= Value / Total Value * 100
For example, to see what percentage is 30 out of 200, you write it as shown below.
= 30 / 200 * 100
And that’s 15%.
In Microsoft Excel, there is no in-built function for calculating percentages. To reach a percentage in Excel, you need to put together the following formula
= Value / Total Value
And then format it as a percentage.
The only difference between a normal percentage formula and the Excel formula is ‘100’.
Let’s see a quick example of how this works.🙈
1. Here’s an image of the total and secured marks for some students.
Calculate the percentage marks secured by each student.
2. Activate a cell and format it as a percentage by going to Home > Number > Formats > Percentage.
4. In the same cell, now write the percentage formula as below.
= B2 / C2
Cell B2 contains the value (the secured marks,) and Cell C2 contains the total value (the total marks).
5. Hit ‘Enter’.
Wow! Kevin scored a whopping 88%.✌
6. Drag and drop the same to all the students to calculate percentages for all.