Mastering Excel: Calculate Salary Increase

Justin Aug 25, 2026

Calculating salary increase percentages can greatly impact employee satisfaction and retention. In today's data-driven business environment, Excel has become the go-to tool for financial calculations, including determining salary raises. Let's explore a simple and effective formula to calculate salary increase percentages in Excel.

How to Calculate Salary Increase Percentage in Excel - ExcelDemy
How to Calculate Salary Increase Percentage in Excel - ExcelDemy

Before we dive into the formula, it's crucial to understand the two key components: the old salary and the new salary. The old salary is the employee's current earnings, while the new salary is the proposed or agreed-upon increase.

How to Calculate Salary Increase Percentage in Excel - ExcelDemy
How to Calculate Salary Increase Percentage in Excel - ExcelDemy

Calculating Salary Increase Percentage

The formula to calculate the salary increase percentage is straightforward. It's a matter of subtracting the old salary from the new salary, dividing by the old salary, and then multiplying by 100 to convert the result into a percentage.

the excelslay sheet is displayed in green and white
the excelslay sheet is displayed in green and white

Here's the formula in Excel syntax:

Basic Formula

Download Employee Base Salary Increase Rate Calculator Excel Template - ExcelDataPro
Download Employee Base Salary Increase Rate Calculator Excel Template - ExcelDataPro

`=(New Salary - Old Salary) / Old Salary * 100`

Let's break this down. The `Old Salary` is the current earnings. The `New Salary` is the intended increase. The subtraction of the old salary from the new salary gives us the raw increase amount. Dividing this by the old salary gives us the increase as a fraction of the current salary. Finally, the multiplication by 100 converts this fraction into a percentage.

Example

How to Create a Salary Sheet in Excel | Easy Formulas & Step-by-Step Guide for Beginners (part-29)
How to Create a Salary Sheet in Excel | Easy Formulas & Step-by-Step Guide for Beginners (part-29)

Suppose an employee's current salary is $50,000 (Old Salary) and we want to give them a 10% raise. The new salary would be:

`=$50,000 * 1.10`

That equals $55,000 (New Salary). Now, we can calculate the increase percentage:

excel budget template,excel tutorial,excel budget,sumif,conditional formatting,budget spreadsheet
excel budget template,excel tutorial,excel budget,sumif,conditional formatting,budget spreadsheet

```lnp; =(New Salary - Old Salary) / Old Salary * 100 =($55,000 - $50,000) / $50,000 * 100 =5,000 / 50,000 * 100 =0.1 * 100 =10% ```

So, the salary increase percentage is indeed 10%, as expected.

Accounting for Uneven Increases

How to Calculating Percentage from Increased Salary in MS Excel
How to Calculating Percentage from Increased Salary in MS Excel
How to calculate percentage in Excel - formula examples
How to calculate percentage in Excel - formula examples
How to Calculate Percentages Common Formulas in Excel
How to Calculate Percentages Common Formulas in Excel
HR Starter Kit - Time Saving Templates
HR Starter Kit - Time Saving Templates
How to Calculate the Average Salary in Excel - 6 Methods - ExcelDemy
How to Calculate the Average Salary in Excel - 6 Methods - ExcelDemy
How to Calculate Percentage in Excel | Calculate Percentage in Excel Totally Easy | Excel Tutorials
How to Calculate Percentage in Excel | Calculate Percentage in Excel Totally Easy | Excel Tutorials
How To Calculate Salary Increase By Percentage
How To Calculate Salary Increase By Percentage

What if the increase isn't a straightforward percentage? For example, suppose the raise isn't 10% across the board, but rather a fixed amount, such as $5,000. In this case, the formula becomes:

Uneven Increase Formula

`=Fixed Increase / Old Salary * 100`

So, if an employee's current salary is $50,000 and they're getting a $5,000 raise, the increase percentage would be:

`=$5,000 / $50,000 * 100 = 10%`

This formula also works in reverse. If you know the increase percentage (say, 20%) and the old salary ($50,000), you can calculate the fixed increase amount as:

`=Old Salary * Increase Percentage`

Plugging in the values:

`=$50,000 * 0.2 = $10,000`

The employee would receive a fixed raise of $10,000.

Excel's powerful, flexible functions make it a staple for calculating salary increase