Docs tower · floor
How to calculate percentage increase in excel is one formula, and Microsoft publishes it with worked numbers: subtract the old figure from the new one, divide by the old one, format the result as a percentage. What the formula does not tell you is which of your rows it will quietly refuse to work on, and why two people can compute the same movement and get different answers.
Microsoft’s own worked example, then the same figures read backwards. Nothing changes
except which number sits under the line. November → December December → November A percentage change is always a share of where you started, which is why a rise and the fall
that undoes it are never the same number. Something that goes up 50% has to come back down by a third
to return to where it was. Nobody is being dishonest when a report shows a 6.75% rise and a 6.32%
fall for the same movement — but a reader who assumes they should match will conclude something
happened, and nothing did.The same £158, twice, and two different percentages
=(2500-2342)/2342
6.75%
Microsoft’s example: earnings of 2,342 then 2,500. “The result is 0.06746 … which is the percentage of increase in earnings.”
=(2342-2500)/2500
−6.32%
The same 158 in the other direction. Larger starting figure, so the same change is a smaller share of it.
Microsoft: Excel shows the #DIV/0! error “when a number is divided by zero (0) … or when a formula
refers to a cell that has 0 or is blank”. That second half matters, because a missing figure
for last month is not visibly a zero. Growth from nothing is not a percentage — there is no
starting quantity for the change to be a share of. The arithmetic runs, and the sign comes out backwards. A loss improving from −100 to −50 gives
A percentage change compares a quantity with itself at another time. Comparing two different
measures — a count against a rate, a total against an average — produces a valid-looking figure
that means nothing. This one Excel cannot catch at all, because both cells hold numbers.Three starting values that break the formula
The original is zero — or the cell is empty
The original is negative
=(-50--100)/-100, which is 50 divided by −100: −50%. The figure halved the
loss and the cell reports a fall. Excel is not wrong; the formula simply has no meaning when the
base is below zero, and it says so by producing a number rather than an error.The two figures are not the same kind of thing
Dealing with the first one properly. Microsoft’s advice on #DIV/0! is worth reading before you reach for a workaround: “Make sure the divisor in the function or formula isn’t zero or a blank cell.” The error is doing its job. It is telling you that a row has no starting value, and in a growth column that is usually a real fact about the data rather than a formatting nuisance.
When it genuinely cannot be avoided — and Microsoft acknowledges that case, “because your formulas are waiting for input from you or someone else” — the tool is IFERROR. The syntax is IFERROR(value, value_if_error), so a growth column becomes something like =IFERROR((B2-A2)/A2, "") and the empty rows stay empty instead of filling the sheet with red.
But know what you have just switched off. Microsoft lists what IFERROR catches: “#N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME? or #NULL!”. All seven. So the wrapper you added to tidy away a division by zero will also silently absorb a #REF! from a deleted column and a #VALUE! from a number that arrived as text. The tidy sheet and the broken sheet look identical. If you use IFERROR, use it on the narrowest formula you can, not around the whole calculation.
Percentage increase against percentage points. The two get used interchangeably and they are different measurements. If a rate rises from 4% to 6%, that is two percentage points and a 50% increase. Both are correct; they answer different questions. Excel computes whichever you asked for and has no way of knowing which one your reader will assume, so the words around the number are doing work that the formula cannot do.
One habit that prevents most of this. Put the old and new figures in their own columns rather than typing them into the formula. Microsoft’s examples use literal numbers because they are demonstrations; in a real sheet, literals mean nobody can see where the figure came from, and the formula bar is the only place a spreadsheet ever explains itself.
The formula, the worked figures, the cause of the #DIV/0! error and the IFERROR syntax are quoted from Microsoft’s own Excel documentation, read on 22 August 2026 and listed below. The reading of the asymmetry, the negative-base case and the warning about IFERROR’s reach are ours.
Four ways in.
Everything about percentage change follows from what sits under the line, including the fact that a rise and its matching fall are different numbers.
A growth column fails on exactly the rows that are most interesting: the ones that started at nothing, or below it.
A growth figure almost always ends up in a chart, and the chart type decides whether it can be read at all.
The figure usually leaves the spreadsheet, and each step out is a chance for its meaning to be lost.
It will not present the formula as the whole answer. Which figure sits under the line decides the result, and that is where the disagreements come from.
It will not recommend wrapping the sheet in IFERROR. Microsoft lists the seven error types it swallows, and six of them are things you would want to know about.
And it will not treat a percentage increase and a percentage point as the same measurement. What holds instead is simple: the formula, the worked figures, the cause of the division error and the IFERROR syntax are quoted from Microsoft’s own Excel documentation, with the date each page was read.
Founder and editor of AI Tools Primer, writing from Palermo, Italy. Thirty-five years of taking computers apart, starting with a Commodore 64 — the long version is on the about page.
Something wrong on this page? Write to aitoolsprimer@gmail.com and it gets fixed.
Written on 22 August 2026.
No affiliate links and no paid placements anywhere on this site. Nobody pays to appear here, and no company has seen this page before you did.
This is general information, not professional advice. Where a page touches money, health, safety or the law, it names its source and the date it was read — and your situation may still differ. See the privacy page and the cookie policy.