Calculate Salary Increase in Excel: Step-by-Step Formula & Guide

Justin Aug 25, 2026

Struggling to calculate a salary increase? Excel has powerful tools to help you. With a bit of setup, you can create a dynamic spreadsheet that automatically calculates raises based on various parameters. Let's explore how you can calculate salary increases in Excel.

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

Before diving into calculations, ensure your Excel data includes the following: Employee Name, Current Salary, and the percentage or amount of the proposed increase. This will provide a solid foundation for your formulas.

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

Basic Salary Increase Calculation

Start by assuming a flat percentage increase for all employees. For example, let's calculate a 5% raise.

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

In cell C2 (assuming Employee Name starts in A2 and Current Salary in B2), use the following formula to calculate the new salary: `=B2*(1+(5/100))`. Drag this formula down to apply it to all employees.

Using an Absolute Increase

How To Calculate Salary In Excel Sheet
How To Calculate Salary In Excel Sheet

Sometimes, Instead of a percentage, you might want to use an absolute increase value. If the increase is a fixed amount like $5,000 regardless of the current salary, use `=B2+5000` in cell C2.

To accommodate different increase amounts, you can list them in a separate column (D) and use `=B2+D2` in cell C2 to tie it to your chosen increase values.

Calculating Differential Raises

How to Calculate Gross Salary in Excel: 3 Useful Methods - ExcelDemy
How to Calculate Gross Salary in Excel: 3 Useful Methods - ExcelDemy

For differential raises, adjust the increase percentage based on an employee's current salary. For instance, you might want to give a larger raise to employees with lower salaries and a smaller increase to those earning more. In this case, use an IF or nested IF function.

Assuming a 5% raise for salaries below $50,000, an 8% raise for salaries between $50,000 and $70,000, and a 3% raise for salaries above $70,000, use the formula: `=IF(B2<50000,B2*1.05,IF(B2<70000,B2*1.08,B2*1.03))` in cell C2.

Automated Salary Increase Report

Calculate Salary Allowances and Tax deduction in Excel by learning center in Urdu/hindi
Calculate Salary Allowances and Tax deduction in Excel by learning center in Urdu/hindi

For more complex calculations, consider using Excel's Data Validation and Vlookup functions. Firstly, create a new sheet with a table outlining your desired salary increase policy (e.g., current salary ranges and corresponding percentage increases).

In your original sheet, use Data Validation to link each employee's salary to the appropriate increase and Vlookup to find the corresponding raise value. Then, use these values in your salary increase formula to create a dynamic, automated report.

Calculate Net Salary by Discover Talent
Calculate Net Salary by Discover Talent
How to Calculate Monthly Salary in Excel (with Easy Steps) - ExcelDemy
How to Calculate Monthly Salary in Excel (with Easy Steps) - ExcelDemy
the excelslay sheet is displayed in green and white
the excelslay sheet is displayed in green and white
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 Net Salary in Excel: 6 Methods - ExcelDemy
How to Calculate Net Salary in Excel: 6 Methods - ExcelDemy
How to Calculate Basic Salary in Excel (3 Methods) - ExcelDemy
How to Calculate Basic Salary in Excel (3 Methods) - ExcelDemy

Formatting and Conditional Formatting

Improve the visual appeal and clarity of your salary increase report by using conditional formatting to highlight significant adjustments. For example, cells where the raise is above 10% could be formatted in red to draw attention to such instances.

izou can also format the new salary column to two decimal places and use the Currency format to represent the final raise values neatly.

With these steps, you've created an efficient, automated system for calculating salary increases in Excel. As any changes to salary or increase policy occur, simply update your formulas, and your reports will adapt accordingly. This leaves you more time to focus on other critical tasks, like celebrating your team's progress and success.