Calculate Percentage Change & Increase the Easy Way

Learn percentage change and increase with step-by-step math, Excel formulas, and pitfalls to avoid.

Why Percentage Change Matters (And Why It's Not Scary) #

You want numbers to tell a story fast. Did revenue actually grow, or is someone just playing PowerPoint games? Percentage change and percentage increase answer that in one line, and you don't need a math PhD or a wall of formulas. You only need the right denominator, a steady hand, and a calculator that doesn't lie.

The secret? It's just comparing "what happened" to "what you started with."


What Percentage Change Means in Plain English #

Percentage change compares a new value to an old value and reports the difference as a share of the old value.

  • Positive result means increase
  • Negative result means decrease

Core formula:

Yes, that's it. Most disasters come from using the wrong old value or from dividing by zero, not from the math itself.


Quick Step-by-Step Example #

Let's say sales moved from 80 to 100.

  1. New − Old = 100 − 80 = 20
  2. Divide by Old = 20 ÷ 80 = 0.25
  3. Convert to percent = 0.25 × 100% = 25% increase

If sales moved from 120 down to 90:

  1. New − Old = 90 − 120 = −30
  2. Divide by Old = −30 ÷ 120 = −0.25
  3. Convert to percent = × 100% → −25% change (which is a 25% decrease)

No drama, just signs.


How to Calculate Percentage Increase Specifically

If you only care about increases, keep the same formula and then check if the result is positive. When it's positive, call it percentage increase. When it's negative, call it a decrease and move on with your day.


Do It in Excel Without Clicking Twelve Menus #

You only need one formula. Put Old in cell B2 and New in C2.

=(C2 - B2) / B2

Format the cell as Percentage with one or two decimals. Copy down the column. If you hate errors:

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

With Labels or Conditions #

Show "increase" or "decrease" with the value:

=IF(C2>B2, (C2-B2)/B2, (C2-B2)/B2)

Same math, but you can add a helper text column:

=IF(C2>B2,"increase","decrease")

Avoid Divide by Zero Explosions #

If Old can be zero, guard it:

=IF(B2=0, "", (C2-B2)/B2)

In real life, when Old is zero you can't compute a meaningful percent change. Use an absolute difference or explain growth "from zero" in words.


Percentage Points vs Percent Change #

If a rate goes from 5% to 7%:

  • Percentage points moved by 2 points
  • Percent change is

Use percentage points when you're comparing rates or shares. Use percent change for most everything else. Mixing them makes dashboards misleading and colleagues grumpy.


Compounding Across Multiple Steps #

Two increases don't add; they compound. If a price rises 10% and then 20%:

  1. After the first increase: multiply by
  2. After the second increase: multiply by
  3. Combined factor:
  4. Net change:

Reverse moves don't cancel either. Up 25% then down 25% leaves you short:

  • Start 100
  • Up 25% → 100 × 1.25 = 125
  • Down 25% → 125 × 0.75 = 93.75
  • Net change = 93.75 − 100 = −6.25 which is −6.25%

So yes, you can be up and still end down. Markets love that trick.


Multi-Period Growth with CAGR #

When your boss says "average growth over several years," they usually want CAGR which smooths the compound path.

If revenue grows from 400 to 625 over 3 years:

  1. New ÷ Old = 625 ÷ 400 = 1.5625
  2. Cube root of 1.5625 ≈ 1.157 (you can use =POWER(1.5625, 1/3) in Excel)
  3. Subtract 1 → 0.157
  4. Convert to percent → 15.7% per year

That matches reality better than averaging yearly percent changes.


Weighted Change for Bundles of Items #

A simple average of percent changes is wrong when items have different sizes. Use weights.

Suppose product A goes from 200 to 220 and product B goes from 50 to 65.

  • A change = 220 − 200 = 20
  • B change = 65 − 50 = 15
  • Total old = 200 + 50 = 250
  • Total change = 20 + 15 = 35
  • Weighted percent change = 35 ÷ 250 = 0.14 = 14%

If you averaged the individual rates:

  • A: 20 ÷ 200 = 10%
  • B: 15 ÷ 50 = 30%
  • Plain average = 20% which overstates the real combined change

Weight it or regret it.


Negative Starting Values and Other Awkward Cases #

Going from −50 to −20:

  • New − Old = −20 − (−50) = 30
  • 30 ÷ −50 = −0.60 = −60%

Mathematically that's a −60% change because the denominator is negative. In plain English the value increased toward zero. If you care about magnitude only, use the absolute baseline:

Still negative. The cleanest fix is to avoid percent change with signed quantities and report the absolute change, or split the metric into magnitude and sign. Your audience will thank you.

When Old = 0 there's no defined percent change. Say "went from 0 to 12" or use ratios like per unit instead.


Clean Presentation That Doesn't Mislead #

  • Round at the end not mid-calculation
  • Show one or two decimals for percentages unless you enjoy clutter
  • Label increase or decrease in a text column for quick scanning
  • If you publish charts, note whether values are percentage points or percent change
  • Cross-check totals before you email the file

Copy-Ready Excel Snippets #

Basic percentage change:

=(C2 - B2) / B2

Display increase/decrease text:

=IF(C2>B2,"increase","decrease")

Guard against divide by zero:

=IF(B2=0,"",(C2-B2)/B2)

CAGR over n years:

=POWER(C2/B2, 1/n) - 1

Replace n with your year count or a cell reference.


Real-World Applications #

ContextExample Use Case
BusinessQuarterly revenue growth, cost reduction tracking
InvestingStock price changes, portfolio performance
MarketingConversion rate improvements, traffic growth
OperationsEfficiency gains, error rate reductions

Common Mistakes and Easy Fixes #

  1. Using the wrong denominator — Always use the original (old) value as the base
  2. Mixing percentage points with percent change — Be clear about which you're using
  3. Adding percentage changes — They compound, not add
  4. Dividing by zero — Guard against zero denominators
  5. Rounding too early — Keep precision until the final step

Quick Reference Cheat Sheet #

  • Formula:
  • Positive result = increase
  • Negative result = decrease
  • Multiple changes = compound (multiply factors)
  • CAGR =
  • Percentage points ≠ percent change

FAQ #

Q: What's the difference between percentage change and percentage increase?

Percentage change can be positive (increase) or negative (decrease). Percentage increase only refers to positive changes.

Q: How do I handle negative starting values?

Be cautious. The math works but interpretation gets tricky. Consider using absolute changes or magnitude-based metrics instead.

Q: Can I add percentage changes together?

No, they compound. If you're up 10% then up 20%, you're up 32% total, not 30%.

Q: What's CAGR and when should I use it?

CAGR (Compound Annual Growth Rate) smooths growth over multiple periods. Use it when you want to know the "average" annual growth rate.

Q: How do I avoid divide-by-zero errors in Excel?

Use =IF(B2=0, "", (C2-B2)/B2) or =IFERROR((C2-B2)/B2, "") to handle zero denominators gracefully.


Wrapping Up #

Percentage change isn't mysterious—it's just a way to put growth and decline into perspective. Master the basic formula, watch out for the common pitfalls, and you'll have a tool that works in spreadsheets, presentations, and real conversations.

Remember: the key is getting the denominator right. Use the original value, guard against zeros, and always double-check your work. Now go forth and calculate those changes with confidence.

All Calculator Tools

Explore our complete collection of mathematical calculators. Each tool is designed for accuracy, speed, and ease of use.

Sum Calculator

Calculate sum, count, and average of numbers quickly and easily.

Use Calculator

Target Sum Finder

Find which of up to 20 amounts add up to a target. Each line is used once, with exact decimal matching.

Use Calculator

Average Calculator

Calculate the mean (average) of multiple numbers with detailed steps.

Use Calculator

Average of 2 Numbers

Quick and simple calculator for finding the average of two numbers.

Use Calculator

Count Calculator

Count how many numbers are in a list, with positive, negative, even, odd, and duplicate breakdowns.

Use Calculator

Variance Calculator

Calculate variance, standard deviation, and statistical measures.

Use Calculator

Summation Calculator

Calculate series using sigma notation with step-by-step solutions.

Use Calculator

Infinite Sum Calculator

Evaluate convergent infinite series including geometric and p-series.

Use Calculator

Riemann Sum Calculator

Approximate definite integrals using various Riemann sum methods.

Use Calculator

Sum of Series Calculator

Calculate arithmetic, geometric, harmonic and custom mathematical series.

Use Calculator

Why Choose Our Calculators?

⚡ Fast & Accurate

Get instant results with mathematical precision you can trust.

🔒 Privacy First

All calculations happen locally in your browser. No data stored or shared.

📱 Mobile Friendly

Works perfectly on all devices - desktop, tablet, and mobile.