We know various methods to calculate the percentage. Even the excel provides us with several ways to calculate the percentage. Percentage is a value that is a proportion, in relation to the whole data.
We can calculate the percentage for certain marks in examination, or calculating % discount for various prices, the percentage change between two numbers and so on.
For calculating percentage first confirm that the cell you are working on is in a percentage format or the parameter you take for calculations has values in terms of percentage. Now, you can build a formula to calculate percentage in a cell with percentage format.
Although we have a wide usage of calculating the percentage. We will discuss some of them below:
- Percentage of a whole
- Percentage of a Number
- Increase & Decrease a Number by Percentage
- Percentage Change between Two Numbers
Steps to Calculate Percentage in Excel 2016:
Before discussing the example for calculating percentage let us see, how to format a cell into percentage?
Step 1: Select a cell that you want to format into a percentage. Right-click on it and select Format Cells among the options.
Step 2: A Format Cells dialog box will appear. Here, in Category select Percentage and in Decimal places select up to how many places you want to see numbers after the decimal. Click OK.
Or
Step 1: You can directly change the format of a cell into Percentage by selecting Percentage, in the drop-down box of Number group of Home tab.
Done you have formatted the cell to show data in percentage.
Percentage of a Total
The best example of this scenario would be calculating the percentage for a test.
See the image below, in a cell C2 we total number of marks for which the test was conducted. In cell B1 we have the number scored in the test by Stieve.
Now, to calculate the percentage of marks, obtain by Stieve in the test, we have to type the formula.
=B21/C1 (confirm that the cell having formula is in a percentage format)
Press Enter to obtain the result.
Percentage of a Number
Here, we can use the example of calculating the amount, for certain discount on the original price.
In the cell B2, we have the original price for the shirt and in the C2 we have the discount offered on the original price in terms of percentage.
Now, we have to calculate the amount that will be reduced from the original price after applying a discount. So in cell D2, I have typed a formula:
=B1*C1
The original price of shirt $80 would be reduced by the $12. Now, the customer has to pay $68.
Note: Here, the discount value is with the % sign which automatically takes the value 15 % as 0.15. Here, we have taken the values in percentage so, we do not need to format the cell with formula into Percentage.
Increase & Decrease a Number by Percentage
We come across this scenario when we get a hike in our salary. Say it announced that your salary has been increased by 10% then how would you calculate the amount of your new salary?
Say your current salary amount is SA, then the formula for the new salary amount would be:
=SA + SA * 10%
Or it can be written as:
= SA * ( 1 + 10% )
In the image below, cell B1 has the current salary of Stieve and cell C1 has increase in the percentage of salary.
So, to calculate the new salary of Stieve the formula will be:
= B1*(1+C1)
The new salary amount of Stieve is 880.
Now, let us study decrease the number by percentage. Consider that the price of a daily product item say sugar falls down by 3%. Then how would you calculate the decreased price of sugar?
The formula to calculate the new decreased price of sugar is:
Say the price of sugar is S:
= S – S * 3%
Or
= S * (1 – 3%)
In the image below you can see that in cell B1 we have the current price of the sugar and in cell C1 we have the % decrease in the price.
To calculate the new decreased price of sugar we apply the formula
=B1 *(1- C1)
The new decreased price of sugar is 77.6.
Percentage change between two number
Now let us take the above example of an increase in salary of Stieve. Earlier, the salary of Stieve was $800 and the new salary of Stieve is $880. Now, we will check the percentage change in the salary of Stieve.
The general formula for evaluating the percentage change between two numbers is:
=(New Value – Old Value) / Old Value
So, the formula to evaluate the percentage change in the salary of Stieve is:
=(C1-B1)/B1 (Keep the formula in the cell, with Percentage format)
That’s all about calculating the percentage in Excel. You can explore it more with different examples and formulas.
Leave a Reply