Ever stared at two columns of numbers in Excel and thought, "Okay, so how much did this actually move?" You're not alone. Percent change is one of those things that sounds like grade-school math until you're staring at a spreadsheet at 11pm trying to figure out if your traffic dropped 12% or 40%.
Here's the thing — Excel makes this stupid easy once you see it done right. But most people either overcomplicate the formula or mess up the sign and end up reporting a gain when they took a loss.
What Is Percent Change in Excel
Forget the textbook version. And percent change in Excel is just a way to show how much a number shifted from one point to another, expressed as a percentage of the starting value. Practically speaking, that's it. You're comparing an old number to a new number and asking: relative to where we started, how big was the jump or the drop?
In practice, it's the same math you'd do on paper. But Excel lets you do it across 10,000 rows without breaking a sweat. And it formats the result so a stakeholder can glance at a cell and immediately get the story.
The Core Idea Behind the Calculation
The logic is always: (new - old) divided by old. That gives you a decimal. Multiply by 100 and you've got a percent. Or — and this is the Excel trick — format the cell as a percentage and skip the multiply entirely.
So if sales were 200 last month and 250 this month, the change is 50. Consider this: divide by 200, you get 0. In practice, 25. That's 25%. Easy.
Absolute vs Relative Change
Worth knowing: percent change is relative* to the starting point. Because of that, a move from 100 to 105 is only 5%. A move from 10 to 15 is a 50% jump. Now, excel doesn't care about that nuance — it just runs the formula. On the flip side, same absolute difference (5 units), wildly different story. You're the one who has to interpret it.
Why It Matters
Why does this matter? Because most people skip the percent part and just show raw differences. And raw differences lie.
Look, if you tell your boss "we gained 300 users," that sounds great. But if you started with 3,000, that's 10%. If you started with 30, that's 1,000%. Context is everything, and percent change is the cheapest context you can add to a report.
And here's what goes wrong when people don't use it: they compare unrelated periods, they mix up which number is "old," or they format the cell wrong and show 0.25 as "25" instead of "25%.Because of that, " I've seen dashboards where a 400% loss was displayed as a positive number because someone dropped a minus sign in the formula. That's how meetings go sideways.
Real talk — whether you're tracking stock prices, website conversions, or your personal budget, percent change turns noise into signal.
How It Works
The meaty part. Let's actually build this.
The Basic Formula (Manual Entry)
Say your old value is in cell A2 and your new value is in B2. Click into C2 and type:
=(B2-A2)/A2
Hit enter. This leads to you'll get a decimal like 0. Here's the thing — 25. Now select C2, go to the Home tab, and click the % icon (or right-click > Format Cells > Percentage). Worth adding: boom. It reads 25%.
That's the whole thing. Don't overthink it.
Dragging the Formula Down
Here's where Excel earns its keep. Once C2 is right, grab the little square at the bottom-right of the cell and drag down. On top of that, every row now calculates its own percent change. Plus, negative means a drop. If A3 was 500 and B3 was 450, C3 becomes -10%. Obvious, but you'd be surprised how many folks freeze when they see a minus sign.
Using Absolute References for a Fixed Baseline
Sometimes you're not comparing row-to-row. You're comparing everything to one starting cell. Say A1 is your baseline and you want to compare B2, B3, B4 against it.
In C2, write:
=(B2-$A$1)/$A$1
The dollar signs lock the reference. That said, drag down and every row measures against that one cell. Super useful for "vs January" type reports.
The Quick Alternative: Format First, Multiply Later
Some people prefer:
=(B2-A2)/A2*100
and then leave the cell as a normal number. That shows 25, not 25%. It's fine — just be consistent. I'd rather format as percent because then the math stays clean and you don't accidentally sum a column of "2500%" thinking it's 25.
Percent Change Across Multiple Periods (Compound)
What if you want year-over-year change across three years? You can chain it, or just compare first to last:
Continue exploring with our guides on convert gpa from 5.0 to 4.0 scale and checks and balances ap gov definition.
=(D2-A2)/A2
That gives total change across the whole span. Worth adding: for year-by-year, do separate columns. Don't try to be clever with one mega-formula unless you really know what you're doing.
Using Excel Tables for Cleaner Work
If you turn your range into a Table (Ctrl+T), your formula auto-fills and your columns get names. Then you can write things like:
=([@New]-[@Old])/[@Old]
Looks fancy, works great, and breaks less when you add rows.
Common Mistakes
This is the part most guides get wrong — they pretend everyone nails it first try. Not true.
Dividing by the new value. I know it sounds simple, but it's easy to miss. Percent change is always old in the denominator. Flip it and your numbers are wrong in a subtle way that won't trip a spellcheck.
Blank or zero old values. If A2 is 0, your formula explodes with #DIV/0!. You need to handle that. Wrap it: =IF(A2=0,"n/a",(B2-A2)/A2). Looks boring, saves your butt in a presentation.
Formatting before the math. If you type =(B2-A2)/A2 and the cell is already percent-formatted, Excel shows 25% — good. But if you then multiply by 100 in the formula, you'll see 2500%. Doubling up is the classic rookie move.
Mixing up rows. Sounds dumb. Happens constantly. You drag a formula and realize row 14's "old" was actually a total row you forgot to exclude. Always eyeball the first five results.
Negative percent confusion. A result of -0.2 formatted as percent is -20%. That's a 20% drop. Don't write "20% change" in a slide and hope nobody asks which direction.
Practical Tips
Here's what actually works when you do this weekly.
Use a helper column for signs. If you want to color gains green and losses red, use Conditional Formatting on the percent column. Two clicks, and your report reads itself.
Keep your raw numbers separate from your calc columns. Don't overwrite A2 with a formula. Leave the source data untouched so you can audit later.
For recurring reports, build a tiny template: columns for Period, Old, New, % Change. Think about it: save it. Now, reuse it. Your future self will thank you.
And honestly? Also, if you're doing this more than once a month, learn the keyboard shortcut for percent format (Ctrl+Shift+%). It sounds trivial. Worth adding: it's not. It adds up.
One more: label your columns clearly. Still, assume the reader knows nothing. That's why "MoM %" beats "% chg" when someone else opens the file. That's how good spreadsheets survive handoffs.
FAQ
How do I calculate percent change in Excel between two columns?
Put the old value in A2, new in B2, and in C2 enter =(B2-A2)/A2. Format C2 as a percentage. Drag the formula down for more rows.
What if the old value is zero?
Excel will show #DIV/0!. Use =IF(A2=0,"n/a",(B2-A2)/A2) to avoid the error and show a text note instead.
**How do I show percent increase only, not
decrease?**
If you only want to display positive changes and hide or neutralize drops, wrap the formula so negatives return zero or a dash: =IF((B2-A2)/A2<0,0,(B2-A2)/A2). Format the result as percent and you’ll see gains only, which is handy for “improvement trackers” where a regression isn’t counted as progress.
Can I calculate percent change across sheets?
Yes. A2)/Sheet1!A2. Here's the thing — b2-Sheet1! Reference the other sheet like =(Sheet2!Just make sure the row alignment is correct—cross-sheet errors are harder to spot because you can’t see both values side by side.
Why does my percent change show as a decimal like 0.25 instead of 25%?
Because the cell is in General or Number format. Think about it: the math is right; only the display is off. Hit Ctrl+Shift+% or right-click > Format Cells > Percentage. Never multiply by 100 in the formula to “fix” it—that creates the 2500% problem from earlier.
Percent change in Excel isn’t advanced math, but it’s where small habits separate a trustworthy spreadsheet from a misleading one. Get the denominator right, guard against zero, keep your raw data clean, and format at the end—not before. Do that consistently and your numbers will hold up whether it’s a quick sanity check or a board deck on Friday afternoon.
