How to Calculate a Percent Increase in Excel

Excel makes percent increase calculations straightforward once you understand the underlying formula — but the way you apply it can vary depending on your data layout, what you're comparing, and how you want results displayed. Here's a clear breakdown of how it works and where the variations start to matter.

The Core Formula for Percent Increase

At its simplest, percent increase is calculated as:

(New Value − Old Value) ÷ Old Value × 100

In Excel, you don't need to multiply by 100 manually if you format the cell as a percentage. The formula in a cell looks like this:

=(B2-A2)/A2 

Where A2 is the original (old) value and B2 is the new value. Format that cell as a percentage, and Excel handles the rest.

This is the foundation. Everything else is a variation on this structure.

Step-by-Step: Setting Up the Calculation

1. Enter Your Data

Place your starting value in one cell (say, A2) and your ending value in another (B2). Label your columns clearly — "January Sales" and "February Sales," for example — so the formula is easy to audit later.

2. Write the Formula

In a third cell (say, C2), type:

=(B2-A2)/A2 

Press Enter. You'll likely see a decimal like 0.15 or 0.08.

3. Format as a Percentage

With C2 selected:

• Go to Home → Number group → Percent Style (%), or
• Press Ctrl + Shift + %

Excel will now display 15% or 8% instead of the raw decimal. You can adjust decimal places using the increase/decrease decimal buttons in the same ribbon group.

Handling Common Variations 📊

Not all percent increase scenarios are the same. A few situations that change your approach:

Comparing Across Multiple Rows

If you have a column of monthly figures and want percent change row by row, you can drag your formula down the column. Make sure your cell references are relative (default in Excel), not absolute, so each row compares correctly to the one above it.

Example for a column of monthly sales in B2:B13, with percent change in C:

=(B3-B2)/B2 

Entered in C3 and dragged down through C13.

Comparing Against a Fixed Baseline

If you're measuring growth against a single fixed value — like a budget target or a baseline year — you need to lock that reference using an absolute reference with the $ symbol:

=(B2-$A$1)/$A$1 

Here, $A$1 stays fixed no matter where you copy the formula.

When the Old Value Is Zero or Negative

This is where things get tricky. If your starting value is zero, the formula returns a divide-by-zero error (#DIV/0!). Wrap the formula in IFERROR to handle it gracefully:

=IFERROR((B2-A2)/A2, "N/A") 

Negative base values are mathematically valid, but the resulting percentage can be counterintuitive or misleading depending on context. Whether a -10 to -5 change represents a 50% improvement or increase depends entirely on how you frame it — Excel will calculate correctly, but interpretation is on you.

Displaying Results: Formatting Options That Matter

You can apply custom number formatting by right-clicking a cell → Format Cells → Number → Custom. A format like +0.0%;-0.0%;0% will automatically show a + sign for positive increases and a - for decreases.

Using Percent Increase in Larger Formulas

Percent increase doesn't have to live in its own isolated cell. You can embed it directly into other formulas:

• Conditional formatting: Highlight cells where growth exceeds a threshold
• IF statements:=IF((B2-A2)/A2>0.1, "Above Target", "Below Target")
• Charts: Use a percent change column as a data series to visualize growth trends

These combinations make the formula significantly more powerful in real reporting scenarios.

Where Results Differ by User and Setup 🎯

The math is consistent — but outcomes in practice depend on factors specific to your situation:

• Your Excel version affects available features. Newer versions (Microsoft 365, Excel 2021) support dynamic arrays and spill ranges, which can change how you structure bulk percent increase calculations across large datasets.
• Data structure matters enormously. A pivot table, a flat list, and a structured table (created with Ctrl + T) each handle formula references differently — especially when dragging formulas or referencing ranges.
• Use case shapes how you display results. A financial model has different formatting needs than a classroom grade tracker or a sales dashboard shared in Teams.
• Skill level with Excel determines whether simpler static formulas or more dynamic approaches (using named ranges, structured table references, or Power Query) make the most sense.

Someone building a monthly board report in Excel 365 with structured tables will approach this differently than someone doing a one-off comparison in a shared workbook on Excel 2016. The formula is the same — but how it fits into your workflow, and how error-prone or flexible you need it to be, depends entirely on what you're working with.