Guide

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

Examples and sources checked on November 21, 2026.

Percentage change+200.00%Increase

Going from -25 to 25 is an increase of 50, which is 200.00% of the size of the starting value (25).

Absolute change+50
Plain spreadsheet result-200.00%

The starting value is negative, so this divides by its size, 25. That convention keeps a plus sign meaning "went up", but the size of the percentage has little meaning. A plain =(B2-A2)/A2 would show -200.00% instead. Many analysts report the change of +50 or "n/m" (not meaningful).

Working

  1. Change: 25 - (-25) = 50
  2. Divide by the size of the starting value, 25: 50 / 25 = 2
  3. Times 100: 2 x 100 = +200.00%

Spreadsheet formula Excel and Google Sheets

Put -25 in A2 and 25 in B2, then format the result cell as Percentage.

Cell formula=(B2-A2)/ABS(A2)
With your numbers=(25-(-25))/ABS(-25)

ABS keeps the sign right when the starting value is negative. For positive starting values it gives the same answer as =(B2-A2)/A2.

Reverse check

Going back from 25 to -25 is -200.00%.

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:

FromToPlain (new - old) / oldSize convention (new - old) / |old|
-2525-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%.