How to Calculate Percentage Increase in Excel (Formula & Examples)

Learn how to calculate percentage increase in Excel using a simple formula. Explore step-by-step instructions, practical examples, and useful tips.

 

How to Calculate Percentage Increase in Excel (Formula & Examples)How to Calculate Percentage Increase in Excel (Formula & Examples)

   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 Value

To 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)/A2

Excel 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.

MonthSales
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:

CellValue
A1January Sales
B1February Sales
C1Percentage Increase
A25000
B26500

Step 2: Enter the Percentage Increase Formula

Click cell C2 and type:

=(B2-A2)/A2

Press 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:

  1. Select cell C2.

  2. Go to the Home tab.

  3. Find the Number section.

  4. Click the Percentage (%) button.

  5. 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:

ProductOld PriceNew PriceIncrease
Laptop$500$60020%
Monitor$200$25025%
Keyboard$40$5025%
Mouse$20$3050%

Assuming the old prices are in column B and new prices are in column C, enter this formula in D2:

=(C2-B2)/B2

Press 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 Value

The difference is in the direction of the change.

SituationOriginal ValueNew ValueResult
Increase10015050%
Increase20025025%
Decrease10080-20%
Decrease500400-20%
No Change1001000%

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

Loaded All Posts Not found any posts VIEW ALL Readmore Reply Cancel reply Delete By Home PAGES POSTS View All RECOMMENDED FOR YOU LABEL ARCHIVE SEARCH ALL POSTS Not found any post match with your request Back Home Sunday Monday Tuesday Wednesday Thursday Friday Saturday Sun Mon Tue Wed Thu Fri Sat January February March April May June July August September October November December Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec just now 1 minute ago $$1$$ minutes ago 1 hour ago $$1$$ hours ago Yesterday $$1$$ days ago $$1$$ weeks ago more than 5 weeks ago Followers Follow THIS PREMIUM CONTENT IS LOCKED STEP 1: Share to a social network STEP 2: Click the link on your social network Copy All Code Select All Code All codes were copied to your clipboard Can not copy the codes / texts, please press [CTRL]+[C] (or CMD+C with Mac) to copy Table of Content