How to Calculate Percentage Increase in Excel

Whether you're tracking sales growth, comparing monthly expenses, or analyzing performance metrics, knowing how to calculate a percentage increase in Excel is one of those skills that pays off constantly. The math behind it is straightforward — but Excel gives you several ways to set it up, and which approach works best depends on how your data is structured and what you need to do with the result.

The Core Formula You Need to Know

Percentage increase measures how much a value has grown relative to its starting point. The standard formula is:

((New Value – Old Value) / Old Value) × 100

In Excel, you don't need to multiply by 100 manually — you just format the cell as a percentage. So the formula becomes:

=(New Value - Old Value) / Old Value 

If your original value is in cell B2 and your new value is in C2, the formula looks like this:

=(C2-B2)/B2 

Once entered, format the result cell as a Percentage (Home tab → Number group → % button, or press Ctrl+Shift+%). Excel handles the ×100 conversion automatically.

Step-by-Step: Setting It Up in a Spreadsheet

Here's how this plays out in a typical layout:

After formatting Column D as a percentage:

• Product A shows 25%
• Product B shows -10% (a decrease)
• Product C shows 50%

Negative results mean the value went down — the same formula handles both increases and decreases without modification.

📊 Variations Based on How Your Data Is Arranged

Not all spreadsheets follow the same layout. The formula stays the same in principle, but your cell references change depending on your structure.

Data in a Single Column (Month-over-Month)

If your values run vertically — January in B2, February in B3, March in B4, and so on — the formula compares each row to the one above it:

=(B3-B2)/B2 

Drag this formula down the column and it automatically adjusts references for each row. This is common for time-series data like monthly revenue or weekly user counts.

Comparing Against a Fixed Baseline

Sometimes you need to measure every value against one fixed reference point — like Q1 performance used as the benchmark for the whole year. In that case, you lock the baseline cell using an absolute reference:

=(B3-$B$2)/$B$2 

The dollar signs ($B$2) keep that reference fixed as you copy the formula down. Without them, Excel shifts the baseline reference with each row.

Using Named Ranges for Clarity

If you're working in a larger model and want the formula to be readable at a glance, you can define named ranges (Formulas → Define Name) and write:

=(NewValue-OldValue)/OldValue 

This doesn't change the math — it just makes the formula easier to audit and share with others.

Common Errors and What They Mean

A few issues show up regularly when people first set this up:

• #DIV/0! error — Your old value is zero, and you can't divide by zero. Wrap the formula in IFERROR to handle it cleanly: =IFERROR((C2-B2)/B2, "N/A")
• Result shows a decimal instead of a percentage — You entered the formula correctly but forgot to format the cell as a percentage. The value 0.25 and 25% are the same number in Excel — formatting is the only difference.
• Result seems wrong after copying — Check whether you needed an absolute reference ($) for the baseline cell but didn't add one.

🔢 Factors That Affect Which Approach Works Best

The right setup isn't universal — it depends on a few variables:

How your data is organized. Side-by-side columns favor one formula structure; stacked vertical data favors another. Forcing the wrong structure wastes time and creates reference errors.

Whether you have a fixed baseline or rolling comparison. Month-over-month analysis and year-over-year analysis need different reference anchoring. Getting this wrong gives you valid-looking numbers that actually mean something different than you intended.

How the output will be used. If you're feeding the percentage into another calculation, you want the raw decimal result (0.25, not 25). If it's for display or a chart label, formatted percentage is cleaner. Mixing these up in a formula chain is a surprisingly common source of errors.

Excel version and environment. The core formula works identically across Excel versions and in Google Sheets. Where things diverge is in features like dynamic arrays or Power Query — relevant if you're calculating percentage changes across large datasets automatically refreshed from an external source.

Skill level and formula maintenance. A simple =(C2-B2)/B2 is fast and easy to write. A version wrapped in IFERROR, using named ranges, formatted conditionally to highlight drops in red — that takes more setup but is far more robust in a shared workbook where others will interact with it.

The formula itself is one of the simplest in Excel. What varies is how much structure you build around it — and that decision is really about how your data flows, who uses the file, and what the numbers need to do next.