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