Calculate Percentage Change & Increase the Easy Way

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:

$$\text{Percent Change}=\frac{\text{New}-\text{Old}}{\text{Old}}\times 100\%$$

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.

$$\text{Percentage Increase}=\{\begin{array}{ll}\frac{\text{New}-\text{Old}}{\text{Old}}\times 100\%,& \text{if New}>\text{Old}\\ \text{not an increase},& \text{otherwise}\end{array}$$

---

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 $(0.07-0.05)÷0.05=0.02÷0.05=0.40=40\%$

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 $1+0.10=1.10$
2. After the second increase: multiply by $1+0.20=1.20$
3. Combined factor: $1.10\times 1.20=1.32$
4. Net change: $1.32-1=0.32=\text{32\%}$

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.

$$\text{CAGR}={\left(\frac{\text{New}}{\text{Old}}\right)}^{1/n}-1$$

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:

$$\frac{|-20|-|-50|}{|-50|}=\frac{20-50}{50}=-0.60=-60\%$$

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 #

---

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: $\frac{\text{New}-\text{Old}}{\text{Old}}\times 100\%$
• Positive result = increase
• Negative result = decrease
• Multiple changes = compound (multiply factors)
• CAGR = ${\left(\frac{\text{New}}{\text{Old}}\right)}^{1/n}-1$
• 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.