Learn how to calculate percentage increase in Excel with easy formulas and practical examples. Follow this step-by-step guide to calculate sales growth, salary increases, price changes, and more.
How to Calculate Percentage Increase in Excel: Formula, Examples & Step-by-Step Guide
Calculating percentage increases is a common task in everyday work. Whether you are comparing monthly sales, tracking business growth, checking salary changes, or analysing price increases, knowing how to calculate percentage increase in Excel can save you time and reduce calculation errors.
The good news is that Excel makes this process incredibly simple. You don't need a complicated formula or advanced spreadsheet skills. With just a basic mathematical formula, you can calculate percentage increases in seconds.
In this guide, you'll learn how to calculate percentage increase in Excel using a simple formula, understand practical examples, compare multiple values, and avoid common mistakes.
What Is Percentage Increase?
Percentage increase tells you how much a value has grown compared to its original amount.
It expresses the difference between an old value and a new value as a percentage of the original value.
For example, imagine your monthly sales increased from $5,000 to $6,000. The increase is $1,000.
To calculate the percentage increase:
Original value: $5,000
New value: $6,000
Increase: $1,000
Percentage increase: 20%
This calculation is useful for measuring business growth, salary increases, expenses, website traffic, product prices, and many other things.
Percentage Increase Formula in Excel
Excel doesn't have a separate built-in function specifically for percentage increase. However, you can calculate it using a simple mathematical formula.
Percentage Increase Formula:
=(New Value-Old Value)/Old ValueTo display the result as a percentage, apply the Percentage Number Format in Excel.
Example:
Suppose your original value is in cell A2 and your new value is in cell B2.
Enter this formula in cell C2:
=(B2-A2)/A2Excel calculates the percentage increase automatically.
If A2 contains 500 and B2 contains 600, the result will be 20% after percentage formatting.
How to Calculate Percentage Increase in Excel Step by Step
Let's understand the calculation with a practical example.
Imagine you run a small business and want to compare your sales from two different months.
| Month | Sales |
|---|---|
| January | $5,000 |
| February | $6,500 |
You want to find out how much your sales increased in February compared to January.
Follow these steps:
Step 1: Enter Your Original and New Values
Open an Excel worksheet and enter the following information:
| Cell | Value |
|---|---|
| A1 | January Sales |
| B1 | February Sales |
| C1 | Percentage Increase |
| A2 | 5000 |
| B2 | 6500 |
Step 2: Enter the Percentage Increase Formula
Click cell C2 and type:
=(B2-A2)/A2Press Enter to calculate the result.
Step 3: Format the Result as a Percentage
Your result may initially appear as 0.3.
To display it as a percentage:
Select cell C2.
Go to the Home tab.
Find the Number section.
Click the Percentage (%) button.
Excel will display the result as 30%.
Step 4: Adjust Decimal Places if Needed
If you want a more precise result, use the Increase Decimal or Decrease Decimal buttons in the Number section.
That's it! You have successfully calculated the percentage increase in Excel.
Practical Examples of Percentage Increase in Excel
Understanding the formula becomes easier when you see how it works in different situations.
Here are some useful examples you can apply to your own spreadsheets.
Example 1: Calculate Sales Growth
Suppose your business generated $12,000 in sales last month and $15,000 this month.
Use this formula:
=(15000-12000)/12000<text>Result: 25% increase</text>
This means your sales grew by 25% compared to the previous month.
Example 2: Calculate Salary Increase
Imagine your previous monthly salary was $3,000, and your employer increased it to $3,600.
Use:
=(3600-3000)/3000<text>Result: 20% increase</text>
Your salary has increased by 20%.
Example 3: Calculate Product Price Increase
Suppose a product previously cost $80 but now costs $100.
Enter:
=(100-80)/80<text>Result: 25% increase</text>
This means the product price has increased by 25%.
Example 4: Calculate Website Traffic Growth
Suppose your website received 20,000 visitors in January and 26,000 visitors in February.
Use:
=(26000-20000)/20000<text>Result: 30% increase</text>
Your website traffic increased by 30% compared to the previous month.
How to Calculate Percentage Increase for Multiple Rows in Excel
If you have a large dataset, you don't need to calculate each percentage increase separately. Excel allows you to apply the same formula to multiple rows.
For example:
| Product | Old Price | New Price | Increase |
|---|---|---|---|
| Laptop | $500 | $600 | 20% |
| Monitor | $200 | $250 | 25% |
| Keyboard | $40 | $50 | 25% |
| Mouse | $20 | $30 | 50% |
Assuming the old prices are in column B and new prices are in column C, enter this formula in D2:
=(C2-B2)/B2Press Enter.
Now select D2 and drag the fill handle (the small square at the bottom-right corner of the selected cell) down to apply the formula to the remaining rows.
Excel will automatically adjust the cell references for each row.
This method is particularly useful when working with product prices, monthly revenue, employee salaries, or business reports.
How to Calculate Percentage Increase Using the IFERROR Function
Sometimes, your original value may be zero or a cell may contain an unexpected value. In such situations, Excel can display an error instead of a percentage.
You can use the IFERROR function to handle calculation errors more neatly.
Use this formula:
=IFERROR((B2-A2)/A2,0)This formula returns 0 if the calculation produces an error.
If you prefer to display a message instead, use:
=IFERROR((B2-A2)/A2,"Check Value")This is helpful when preparing reports or sharing spreadsheets with other people.
Keep in mind that an original value of zero does not have a mathematically defined percentage increase. The IFERROR formula simply provides a cleaner display; it does not calculate a meaningful growth rate in that situation.
Difference Between Percentage Increase and Percentage Decrease
Percentage increase and percentage decrease use the same basic formula:
=(New Value-Old Value)/Old ValueThe difference is in the direction of the change.
| Situation | Original Value | New Value | Result |
|---|---|---|---|
| Increase | 100 | 150 | 50% |
| Increase | 200 | 250 | 25% |
| Decrease | 100 | 80 | -20% |
| Decrease | 500 | 400 | -20% |
| No Change | 100 | 100 | 0% |
A positive result indicates an increase, while a negative result indicates a decrease.
This makes the formula useful for analysing both growth and reductions without needing separate calculations.
Common Mistakes to Avoid When Calculating Percentage Increase
Even though the formula is simple, a few mistakes can lead to incorrect results.
Using the New Value as the Original Value: Always divide the difference by the original value, not the new value.
Forgetting Percentage Formatting: Excel may show 0.25 instead of 25%. Apply Percentage formatting to make the result easier to understand.
Dividing by Zero: If the original value is zero, the percentage increase is undefined. Check your original data before calculating.
Reversing Cell References: Make sure the formula subtracts the old value from the new value.
Multiplying by 100 Twice: If you use Excel's Percentage formatting, you don't need to multiply the formula by 100. Otherwise, the displayed result will be incorrect.
Frequently Asked Questions (FAQs)
1. What is the formula for percentage increase in Excel?
Use =(New Value-Old Value)/Old Value and format the result as a percentage.
2. How do I calculate a 10% increase in Excel?
Use =A2*1.10 to increase the value in A2 by 10%.
3. Can Excel calculate percentage increases automatically?
Yes. Enter the percentage increase formula and drag the fill handle down to calculate results for multiple rows.
4. Why is my percentage increase showing as a decimal?
Your cell is probably formatted as General or Number. Select the cell and click the Percentage (%) button.
5. Can I calculate percentage increase when the original value is zero?
A percentage increase from zero is mathematically undefined. You can use IFERROR to display a message or alternative value, but it won't provide a valid percentage growth rate.
Final Thoughts
Calculating percentage increase in Excel is easy once you understand the basic formula. Simply subtract the original value from the new value, divide the difference by the original value, and format the result as a percentage.
The formula is useful for tracking business growth, comparing sales, calculating salary increases, monitoring website traffic, and analysing changing prices.
Once you become comfortable with this calculation, you can use it across almost any Excel spreadsheet to understand how values change over time.

COMMENTS