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

Justin Aug 25, 2026

Calculating a salary increase is a crucial step in re-evaluating and enhancing an employee's compensation. With Excel's robust features, you can create a straightforward and efficient way to calculate future salary amounts. This article will guide you through the process, helping you to effectively manage and analyze salary data.

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

Firstly, let's consider the two primary methods to calculate a salary increase: a percentage-based increase and a fixed amount increase. Each approach has its strengths, and knowing how to implement both in Excel can cater to different situations. Let's dive into the step-by-step process for each method.

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

Percentage-Based Salary Increase

Applying a percentage increase to an existing salary is a common method for determining new compensation. This approach allows employees to share in the company's overall growth and success.

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

To calculate a percentage-based salary increase, you'll use the formula: New Salary = Current Salary * (1 + Percentage Increase). Here's how to incorporate this into your Excel sheet:

Applying the Percentage Increase Formula

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

Assuming your current salary is in cell A1 (e.g., $50,000) and the desired percentage increase is 5% or 0.05, enter the following formula in a new cell for the new salary: =A1*(1+B1), with B1 containing the percentage (0.05).

This formula multiplies the current salary by the total percentage increase (1 + 0.05 = 1.05). Once you've entered the data, you'll see the new salary in the destination cell.

Automating the Calculation for Multiple Employees

How to Calculate Monthly Salary in Excel (with Easy Steps) - ExcelDemy
How to Calculate Monthly Salary in Excel (with Easy Steps) - ExcelDemy

To apply this calculation to a list of employees, place their salaries in column A (A2:A100) and the corresponding percentage increases in column B (B2:B100). In cell C2, enter the formula =A2*(1+B2) and drag the formula down to C100. This handles all salary increase calculations at once, making your workbook both efficient and dynamic.

Fixed Amount Salary Increase

A fixed amount increase is beneficial for occasions when a specific amount is budgeted for raises, regardless of the employee's current salary.

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

To calculate the new salary using a fixed amount increase, you'll use the formula: New Salary = Current Salary + Fixed Amount. Follow these steps to apply this method:

Calculating the Fixed Amount Increase

Calculate Net Salary by Discover Talent
Calculate Net Salary by Discover Talent
HR Starter Kit - Time Saving Templates
HR Starter Kit - Time Saving Templates
How To Calculate Salary In Excel Sheet
How To Calculate Salary In Excel Sheet
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 Salary In Excel Sheet  At Mallorysoraya
How To Calculate Salary In Excel Sheet At Mallorysoraya
Master Employee Salary Calculation with TAX Using IF Function – Simple & Accurate Guide
Master Employee Salary Calculation with TAX Using IF Function – Simple & Accurate Guide
Vergütung und Gehaltserhöhung Matrix HR Vorlage | Mitarbeiter Gehalts & leistungsbasiertes Gehaltsplanungs-Tool
Vergütung und Gehaltserhöhung Matrix HR Vorlage | Mitarbeiter Gehalts & leistungsbasiertes Gehaltsplanungs-Tool

Suppose you have a budget of $5,000 for raises and you want to distribute it equally among five employees. Enter the formula =5000/5 in a cell to find the fixed amount per employee ($1,000 in this case).

Now, in the new salary cell next to the current salary, enter the formula =A1+B1 (assuming the fixed amount is in cell B1). This adds the fixed amount to the current salary, giving you the new amount.

Applying the Fixed Amount to Multiple Employees

To apply the fixed amount increase to a list of employees, input their salaries in column A (A2:A100) and the fixed amount in a cell (e.g., B1 = $1,000). In cell C2, enter the formula =A2+B1 and drag it down to C100. This will automatically calculate the new salaries for everyone in your list.

In conclusion, understanding and implementing these methods in Excel enables you to manage and predict salary changes effectively. Whether you're applying percentage-based or fixed amount increases, Excel's formulas and functions simplify the process and help you stay organized. By mastering these techniques, you can enhance your human resources management skills and make informed decisions regarding employee compensation.