How to Calculate Percent Increase in Excel

Whether you're tracking sales growth, monitoring price changes, or comparing monthly performance figures, knowing how to calculate percent increase in Excel is one of the most practical spreadsheet skills you can build. The math is straightforward, but Excel gives you several ways to apply it — and the right approach depends on how your data is structured and what you want to do with the result.

The Core Formula Behind Percent Increase

Before touching Excel, it helps to understand what percent increase actually means mathematically:

Percent Increase = ((New Value − Old Value) / Old Value) × 100

In plain terms: you find the difference between two values, divide that difference by the original value, then multiply by 100 to express it as a percentage. Excel handles the multiplication automatically once you format the cell as a percentage, which keeps your formulas cleaner.

Building the Basic Percent Increase Formula in Excel

Assume your old value is in cell B2 and your new value is in cell C2. The formula in D2 would be:

=(C2-B2)/B2 

That's it. Once entered, format cell D2 as a Percentage (Home tab → Number group → % button, or press Ctrl+Shift+%). Excel multiplies the decimal result by 100 and displays the percent symbol automatically.

If you want the raw number without percentage formatting:

=(C2-B2)/B2*100 

This returns a plain number like 12.5 rather than 12.5%. Which version you use depends on whether you're feeding the result into further calculations or displaying it for a report.

Applying the Formula Across Multiple Rows

One of Excel's biggest advantages is that you can write the formula once and drag it down the column to apply it to an entire dataset. Click the cell containing your formula, then grab the fill handle (the small square at the bottom-right corner of the cell) and drag it down. Excel adjusts the row references automatically.

If your old value is always in a fixed cell — say, a baseline figure in B1 — use an absolute reference to lock it:

=(C2-$B$1)/$B$1 

The dollar signs tell Excel not to shift that reference as you copy the formula down. This is useful for year-over-year comparisons where everything is measured against one fixed starting point.

Handling Negative Values and Zero Baselines

Two edge cases come up regularly:

Negative old values — If B2 contains a negative number, the formula will still calculate, but the result may be counterintuitive. A move from -50 to -25 produces a 50% "increase" that's mathematically correct but might read as improvement depending on context. Always sanity-check results when negative numbers are involved.

Zero as the old value — Dividing by zero produces a #DIV/0! error in Excel. Wrap your formula in an IFERROR function to handle this gracefully:

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

This returns "N/A" instead of an error when the original value is zero, keeping your spreadsheet clean.

Using Excel Functions Alongside the Formula

Excel doesn't have a single dedicated "percent increase" function, but several built-in tools pair well with the formula:

A combined formula that labels direction might look like:

=IF((C2-B2)/B2>0,"Increase","Decrease")&": "&TEXT((C2-B2)/B2,"0.00%") 

This returns a string like Increase: 14.29% — handy for dashboards or summary tables where plain numbers need context. 📊

Percent Increase vs. Percent Difference — Know the Distinction

These two calculations are often confused but mean different things:

• Percent increase always divides by the original (starting) value. Direction matters — it implies a before-and-after relationship.
• Percent difference divides by the average of the two values. It's used when neither value is clearly the "starting point," such as comparing two competitors' prices.

Using the wrong formula against the wrong data type is one of the most common errors in business spreadsheets. If someone asks "how much did revenue grow?" that's percent increase. If someone asks "how different are these two prices?" that's percent difference.

Formatting Choices That Affect How Results Display

Excel's percentage formatting can trip people up. When you type 0.15 into a cell and apply percentage format, Excel displays it as 15% — because it assumes you entered a decimal. But if you type 15 and then apply percentage format, Excel displays 1500%, because it multiplies the raw number by 100.

This means the formula =(C2-B2)/B2 combined with percentage formatting will display correctly without multiplying by 100 inside the formula. Adding *100 inside the formula and applying percentage formatting will inflate the result by a factor of 100. Pick one approach and stay consistent across your workbook.

Variables That Shape Your Specific Setup 🔢

Several factors determine how you'll actually implement this in practice:

• Data layout — Single column comparisons vs. pivot tables vs. cross-sheet references each require slightly different formula structures
• Excel version — Older versions of Excel (pre-2016) lack some dynamic array behaviors that affect how formulas populate across ranges
• Data volume — A two-column table for 10 rows is handled differently than a 50,000-row dataset where performance and named ranges become relevant
• Output destination — Whether the result feeds a chart, a printed report, or a linked Power BI dashboard affects which formatting approach makes sense
• Audience — A formula-heavy cell is fine for internal analysis; a clean TEXT-formatted result may matter more for stakeholder-facing sheets

The underlying math doesn't change, but the cleanest way to build, format, and structure your workbook depends on where your data lives, how it's used downstream, and how comfortable you are maintaining the spreadsheet over time.