Calculate Salary Increase Percentage: Excel Formula Guide

Justin Aug 25, 2026

Looking to calculate your salary increase percentage? You're in the right place. Excel, with its robust features, can help you perform this calculation with ease. In this guide, we'll explore the step-by-step process of creating a salary increase percentage formula in Excel, ensuring you're well on your way to optimized compensation management.

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

But first, let's cover some basics. A salary increase percentage is a critical aspect of employee compensation, reflecting the growth in an employee's earnings over time. It's typically expressed as a percentage of the current salary. Here's a simple formula to calculate it: (New Salary - Old Salary) / Old Salary * 100%. Now let's dive into how to implement this in Excel.

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

Setting Up Your Excel Workbook

Before we start, ensure your Excel workbook is set up with the necessary columns. You'll need at least two: 'Old Salary' and 'Salary Increase Percentage'. The 'New Salary' can be calculated using our formula, so you don't need a separate column for it.

HR Starter Kit - Time Saving Templates
HR Starter Kit - Time Saving Templates

Here's a simple example of how your data might look:

EmployeeOld SalarySalary Increase Percentage
John500005
Jane550007
How to Calculate Salary Increase Percentage in Excel - ExcelDemy
How to Calculate Salary Increase Percentage in Excel - ExcelDemy

Calculating the New Salary

To calculate the new salary, we'll use the formula: =(Old Salary * (1 + Salary Increase Percentage/100)). Let's break this down:

  • Old Salary is the value from the 'Old Salary' column.
  • Salary Increase Percentage is the value from the 'Salary Increase Percentage' column, divided by 100 to convert it from percentage to a decimal.
  • The whole thing is enclosed in parentheses (to ensure the right order of operations) and multiplied by the old salary.
excel budget template,excel tutorial,excel budget,sumif,conditional formatting,budget spreadsheet
excel budget template,excel tutorial,excel budget,sumif,conditional formatting,budget spreadsheet

For example, John's new salary would be: =(50000 * (1 + 5/100)) = $52500.

Automatic Calculation for All Employees

To calculate the new salary for all employees, we can use the Excel 'AutoFill' feature. After entering the formula in one cell, click and drag the small square in the bottom-right corner of that cell to fill the formula down for all employees. This ensures all new salaries are calculated automatically.

Excel Tips
Excel Tips

Here's how your table should look now:

EmployeeOld SalarySalary Increase PercentageNew Salary
John50000552500
Jane55000758850
the excelslay sheet is displayed in green and white
the excelslay sheet is displayed in green and white
How to Calculating Percentage from Increased Salary in MS Excel
How to Calculating Percentage from Increased Salary in MS Excel
How To Calculate Increase Salary With Percentage
How To Calculate Increase Salary With Percentage
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)
Salary Increments in Excel #shorts #excelshorts #shorts #excel #exceltips
Salary Increments in Excel #shorts #excelshorts #shorts #excel #exceltips
How To Calculate Salary Increase By Percentage
How To Calculate Salary Increase By Percentage
How to Calculate Percentages Common Formulas in Excel
How to Calculate Percentages Common Formulas in Excel

Visualizing Salary Increases

Want to visualize the salary increases? You can create a chart to display the old and new salaries side by side. This can help you see exactly how much each employee's salary has increased.

Here's how to create a chart:

  1. Select the 'Old Salary', 'Salary Increase Percentage', and 'New Salary' columns.
  2. Go to the 'Insert' tab and click 'Bar' to insert a clustered column chart.
  3. Right-click the chart, go to 'Select Data', and click 'Switch Row/Column'. This will display the old and new salaries side by side.

You can now clearly see each employee's old salary and new salary, making it easy to compare and understand their increase.

Adjusting for Cost of Living or Inflation

In some cases, you may want to adjust the salary for changes in the cost of living or inflation. This involves calculating the salary increase percentage from the new salary. The formula for this is: ((New Salary / Old Salary) - 1) * 100%.

For example, if John's new salary is $52500, and the cost of living has increased by 3%, the formula would be: ((52500 / 50000) - 1) * 100% = $5.6%. This means his salary needs to increase by 5.6% (after his initial 5% increase) to account for the rise in the cost of living.

And that's a wrap! You've now learned how to calculate salary increase percentages, new salaries, and even account for factors like the cost of living. With these skills, you're well-equipped to manage employee compensation in Excel. Happy calculating!