Percentage change with negative numbers or from zero
Percentage change with negative numbers, and percent change from zero, are where calculators and spreadsheets quietly disagree. This guide explains each convention, shows what it does to real examples, and suggests what to report instead.
- Zero: no percentage exists, and what to say instead
- Negative bases: the size convention and its limits
- Loss to profit, temperatures, tiny bases
Percent change from zero
Percentage change divides by the starting value. When the start is zero, there is nothing to divide by: going from 0 to 5 is a real increase of 5, but no percentage describes it. It is not infinitely large in any useful sense, and it is not 100%.
What to do: report the absolute change (up 5), or call it "new". Financial tables often write "n/m" for not meaningful. Going from 0 to 0 is simply no change. The calculator above shows "Not defined" with the absolute change rather than an error, and the spreadsheet guard =IF(A2=0,"n/m",(B2-A2)/ABS(A2)) (decimal comma locales: =IF(A2=0;"n/m";(B2-A2)/ABS(A2))) does the same in a sheet.
Negative starting values: the size convention
With a negative start, the plain formula gives a sign that reads backwards. Some calculators, including CalculatorHub.com, divide by the size (the absolute value) of the starting number instead, and so does this site:
| From | To | Plain (new - old) / old | Size convention (new - old) / |old| |
|---|---|---|---|
| -25 | 25 | -200.00% | +200.00% |
| -10 | -25 | +150.00% | -150.00% |
The convention keeps the sign honest: a rise shows as positive and a fall as negative. What it cannot do is make the size mean anything. From -25 to 25 is "+200.00%", but from -1 to 1 is also "+200.00%", even though one moved 50 and the other moved 2. The percentage is a ratio to a number that is not a sensible base.
Loss to profit
A company that lost 4 million last year and made 6 million this year improved by 10 million. The size convention calls it +250.00%; the plain spreadsheet formula calls it -250.00%. Neither number helps a reader. Company reports and analysts usually show the change in dollars and mark the percentage as n/m, and that is the better practice: "up 10 million, from a loss to a profit".
Temperatures
From -5 °C to 10 °C is a rise of 15 degrees, which the size convention calls +300.00%. The same temperatures in Fahrenheit are 23 °F and 50 °F, a rise of +117.39%. Same weather, two wildly different percentages: Celsius and Fahrenheit put zero in arbitrary places, so percentage changes on them mean nothing. Report degrees. Only a scale with a true zero, such as kelvin, supports percentages.
Tiny starting values
Even with positive numbers, a very small base produces huge percentages. From 2 to 50 is +2,400.00%. That is correct arithmetic, but a reader learns more from "25 times as many" or the counts themselves. The calculator flags any result of 1,000% or more and shows the multiplier.
Log change, and what to report
The log change, 100 x ln(new / old), is symmetric and adds up over time, which is why Törnqvist, Vartia and Vartia argued for it as a measure of relative change. From 2 to 50 it is 321.89 log points, and back down is -321.89. It needs both values positive, so it does not rescue zero or negative cases.
- Start is zero: the absolute change, or "new".
- Start is negative, or the value crosses zero: the absolute change, with n/m for the percentage. If you must give a percentage, say it divides by the size of the starting value.
- Values are rates: the change in percentage points.
- Comparing two values with no order, one of them negative: the absolute gap; the percent difference page has a variant for this.
- Very small base: the multiplier or the counts.
In a spreadsheet
The plain =(B2-A2)/A2 gives the backwards sign for negative bases and #DIV/0! for zero. Use =IF(A2=0,"n/m",(B2-A2)/ABS(A2)) (decimal comma locales: =IF(A2=0;"n/m";(B2-A2)/ABS(A2))), or flag negative bases separately with =IF(A2<=0,"n/m",(B2-A2)/A2) (decimal comma locales: =IF(A2<=0;"n/m";(B2-A2)/A2)) if you prefer not to report those percentages at all. The Excel guide has more.
Questions people ask
What is the percent change from 0 to a number?
It is not defined. Report the absolute change instead.
Can percentage change be negative when both numbers are negative?
Yes. With the size convention, from -10 to -25 is -150.00% because the value fell. A plain spreadsheet formula would say +150.00%.