### 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

## 0 Comments