In this short tutorial, I will show you how to calculate salary increase percentage (%) in **Excel** from your recent raise. Also, you will learn how to calculate the amount of raise from the salary increase percentage (%). In every calculation, you will be able to see the amount of difference made in your per paycheck.

## Calculate Salary Increase Percentage in Excel: 2 Different Methods

Whenever our salary is increased, we usually have either of the two situations below.

- We have the
**Amount of Raise**but want to find out the**Percentage Increase**in salary. - Â We have
**Percentage increase**in salary but want to find out the**Amount of Raise**in salary.

In our template, we have shown both of the cases.

So let’s learn how to deal with the first case.

### 1. Salary Increase Percentage (%) Calculation from the Raise

From your **Paycheck Stub**, you will take the **Gross Salary**. Donâ€™t deduct anything from the Gross Salary like Medical Tax, Social Security Tax, Fed Tax or anything else. Normally Gross Salary and Deductions are shown in different columns. So, it will be easy for you to find out the **Gross Wages** from the paycheck stub.

A sample Paycheck stub.

In the following image, youâ€™re seeing the whole process I have used to calculate the Salary Increase Percentage from the Salary Raise.

__Input / Output values in the Excel Template:__

**Gross Income (Per Paycheck):**Input your Gross Income value in cell**C4**.**You Get Paid:**This is a drop-down list. Input your payment frequency. Though I have input a lot of values in the list, normally employees gets paid**Weekly, Bi-weekly,**and**Monthly**.

**Number of Payments/Year:**This is the value you will get from a**VLOOKUP**table. In the**Payments**worksheet (a hidden worksheet), you will get a range named as**payment_frequency**. We have applied**the VLOOKUP function**to get the**Payment Frequency**in a year.

`=VLOOKUP(C5,payment_frequency,2,FALSE)`

**Annual Salary:**This is also an output. We got it by multiplying the**Gross Income**(Per Paycheck) by the**Number of Payments per Year**:

`=C4*C6`

**Amount of Raise:**It will be input by you. Input the raise you got from your company in cell**C8**.**New Salary:**Your new salary will be the sum of your old**Annual Salary**and**Raise**:

`=C7 + C8`

**Salary Increased (/Decreased):**We will calculate using this formula:

`=(C10-C7)/C7`

**=(New Annual Salary â€“ Old Annual Salary)/Old Annual Salary**

We use **Percentage** format to format this cell.

**New Gross Income:**To get the New Gross Income (per paycheck), you have to divide your new annual income by the total number of payments per year:

`=C10/C6`

**Change Per Paycheck:**Just subtract your new**Per Paycheck**from the old**Per Paycheck**:

`=C12-C4`

### 2. New Salary and Raise Calculation from the Salary Increase Percentage (%)

In this case, the dataset will provide your Salary Increase Percentage, we shall calculate your new Gross Income and Raise.

Now, check out the following image. You should notice that this time we give the **Salary Increase Percentage**Â instead of the **Raise** amount.

__Input / Output values in the Excel Template:__

**Gross Income (Per Paycheck):**Input your Gross Income.**You Get Paid:**Select your payment frequency from the drop-down list.**Number of Payments/Year:**We used Excel**VLOOKUP**formula to get this value. See the above explanation.**Annual Salary:**We calculated annual Salary by multiplying the**Gross Income**by the**Total Number of Payments per Year**.**Salary Increased (/Decreased):**Previously, in this place, we have used the**Amount of Raise**This time, we are using the percentage increase. You will input this value into the template.**New Salary:**Calculate new Salary using this formula:

**= Old Salary x (1 + Percentage Increase)**

`= C20*(1+C21)`

**Amount of Raise:**It is the subtraction of New Annual Salary and Old Annual Salary:

`=C23-C20`

**New Gross Income:**Division of the**New Annual Salary**and the**Total Number of Payments per Year**:

`=C23/C19`

**Change Per Paycheck:**Difference of the New Per Paycheck and the Old Per Paycheck:

`=C25-C17`

**Download Practice Workbook**

Download the Excel template that I have made while writing this article.

## Conclusion

This is how to calculate the salary increase percentage (%) in Excel from Gross Pay and Raise. I have also shown how to calculate the raise from the percentage increase. Hope this article and the Excel template help you. Moreover, if you have any further queries, please let us know by commenting in the post.

**<< Go Back to Salary | Formula List | Learn Excel**

Suppose My current Salary is Rs 307584 annually, If I get a 10% increment every year, how much time (year/months) will it take to get a annual salary of 7500000. How to set value/formulas in excel to get desired result ?

Hello FAIS,

Follow these steps to get your desired result.

`=LN(C6/C4)/LN(1+C5)`

In the formula,

C6refers to the desired salary (75000000),C4refers to the current salary (307584) andC5refers to the increment percentage (10%).`=INT(C8)&" years " & INT(MOD(C8*12,12))&" months"`

Here,

C8refers to the required time in years.Excelworksheet like the following image given below to get the desired result.