O5 Ways How to Calculate Percentages Increase In Excel | All About Percentages In Excel

In this tutorial, you ’ll learn five different ways how to calculate percentage increase in Excel. All of them are correct and can be used interchangeably to get the same result. There are no specific functions for calculating percentage In MS Excel so you have to use the skills you were taught in your math's class at school!

Finding a percentage of a value

in this example you have a initial value and you have to find out a specific percentage of initial amount for example shown as below image.
Example 1


Way No 1 How to calculate Percentage Increase In Excel

here we need to increase these three values that appear in the column C by 10%, and we need the result to show in the column D.
Percentage Trick
1.1 = 10%
1.2 = 20%
1.3 = 30%
Formula  =C10*E9


Way No 2 How to Calculate Percentage Increase in Excel

this is third way how to calculate interest increase in excel, here we need to increase these values that appear in the column B with 12%, and we need show the result in the column C.
Percentage Trick
1.1 = 10%
1.2 = 20%
1.3 = 30%
Formula  =b27*1.12

Way No 3 How to Calculate Percentage Increase in Excel

this is another way how to calculate interest increase in excel, here we need to increase these values that appear in the column B with 10%, and we need show the result in the column C.
Percentage Trick
110% = 10%
120% = 20%
150% = 50%
Formula  =b41*110%

Way No 4 How to Calculate Percentage Increase in Excel

this is one more way how to calculate interest increase in excel, here we need to increase these values that appear in the column B with 10%, and we need show the result in the column C.
Percentage Trick
0.1 = 10%
0.2 = 20%
0.5 = 50%
Formula  =b59+b59*0.1

Way No 5 How to Calculate Percentage Increase in Excel

this is another way how to calculate interest increase in excel, here we need to increase these values that appear in the column B with 10%, and we need show the result in the column C.
Percentage Trick
10% = 10%
20% = 20%
50% = 50%
Formula  =b41*110%

How to calculate pay rise with category wise behalf on old salary structure 

In this example we will calculate the rising value of a initial value , for example a company rise their employee salary in percentage behalf of old salary so how to calculate raised value
A company is about to give its staff a pay rise.
The wages department need to calculate the increases.
Staff on different grades get different pay rises.



Example 2
A company is about to give its staff a pay rise.
The wages department need to calculate the new salary including the % increase.
Staff on different grades get different pay rises.


Finding a percentage increased value 

This is another example of percentage calculation and in this example we will learn how to find a percentage value behalf of initial value.

Finding one value as percentage of another

in this example suppose you have two value and you have required to find out the percentage one value of another value.  

Download Practical Exercise 




Post a Comment

0 Comments