Excel Formula for Salary Increase Percentage

Justin Aug 25, 2026

Calculating a salary increase percentage is a common task in finance and human resources, and Excel offers powerful tools to streamline this process. Knowing the right formula can save you time and help you maintain accuracy in your projections. Let's dive into the Excel formulas and techniques used to calculate salary increase percentages.

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

Understanding the basic concept is paramount before we delve into the Excel formulas. The salary increase percentage is calculated by dividing the increase amount by the original salary, then multiplying the result by 100 to convert it into a percentage. The increase amount equals the new salary minus the original salary. Now, let's see how Excel can automate these calculations.

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

Basic Excel Formulas for Salary Increase

Before applying more advanced formulas, it's crucial to understand the fundamental salary increase calculation in Excel. To calculate the increase amount and then the percentage, you can use the following formulas:

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

Increase Amount: `=New Salary - Old Salary`

Increase Percentage: `=(Increase Amount / Old Salary) * 100`

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

###

Using Excel's Goal Seek Feature

Excel's Goal Seek tool is an invaluable feature for finding the required salary increase to achieve a specific percentage. Here's how to use it:

1. Click on the cell containing the final salary percentage you want to achieve (e.g., C2).

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

2. Go to the 'Data' tab, then click on 'What-If Analysis', and select 'Goal Seek'.

3. In the 'Set cell' field, click on the cell containing the salary increase percentage (e.g., B2).

4. In the 'To value' field, enter your desired salary increase percentage (e.g., 5).

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

5. In the 'By changing cell' field, click on the cell containing the increase amount (e.g., A2).

###

Calculating Salary Increases for Multiple Employees

Excel Tips
Excel Tips
How to Calculating Percentage from Increased Salary in MS Excel
How to Calculating Percentage from Increased Salary in MS Excel
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)
How to Calculate Percentages Common Formulas in Excel
How to Calculate Percentages Common Formulas in Excel
How To Calculate Salary Increase By Percentage
How To Calculate Salary Increase By Percentage
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 Increase Salary With Percentage
How To Calculate Increase Salary With Percentage

If you're working with a list of employees and need to calculate their new salaries and increase percentages simultaneously, use structured references with Excel Tables. Here's how:

1. Convert your data range into an Excel Table (Insert > Table).

2. In the 'New Salary' column, use the formula `=Old Salary * (1 + Increase Percentage/100)`.

3. In the 'Increase Amount' column, use the formula `=New Salary - Old Salary`.

4. In the 'Increase Percentage' column, use the formula `=(Increase Amount / Old Salary) * 100`.

Handling Complex Salary Increase Scenarios

In real-world situations, salary increases might be based on specific rates or tiers. To account for these complexities, consider using Excel's IF() and INDEX() functions, combined with lookup tables for rates.

For example, suppose you have a table (Sheet1) with employee names, current salaries, and their respective increase rates based on performance tiers. To calculate their new salaries, use the following formula on a new sheet:

`=IF(Employee Tier = "Excellent", INDEX(Rates, 1, 2), IF(Employee Tier = "Good", INDEX(Rates, 2, 2), INDEX(Rates, 3, 2))) * Old Salary`

###

Visualizing Salary Increases with Charts

To communicate salary increase data effectively, consider creating charts. Excel offers various chart types to suit your needs:

1. Bar charts are ideal for comparing individual or group increases.

2. Line charts can help illustrate increases over time.

3. Pie charts can display the distribution of increase rates or tiers.

Embracing Excel's versatile functions and features allows you to calculate salary increase percentages efficiently and present the resultseffectively. By mastering these techniques, you'll save time and reduce errors in your future salary planning tasks. Keep refining your skills and exploring Excel's endless capabilities to unlock further productivity gains.