Percentage change calculator
A percent change calculator that does more than give a number. Type an old value and a new value to calculate percentage change, and you get a sentence about your own numbers, the working, the Excel and Google Sheets formula, and the reverse check.
- Handles a zero or negative starting value honestly
- Formulas in comma and semicolon forms
- Worked examples from dated official statistics
How to calculate percentage change
Percentage change compares a new value with an old one and expresses the gap as a share of the old value. The formula is (new - old) / old x 100. A positive answer is an increase and a negative answer is a decrease.
The calculator above starts with 100 going to 125. The change is 25, and 25 out of 100 is 25.00%, so the value rose by 25.00%. The multiplier says the same thing a different way: the new value is 1.25 times the old one.
- Subtract: new minus old. Keep the sign.
- Divide by the old value, the one you are measuring from.
- Multiply by 100 and add the percent sign.
Dividing by the old value is the whole trick. If you divide by the new value instead, you are answering a different question: how far back down the old value sits from the new one. That is why the result panel always shows the return trip.
Points or percent: the BLS index example
Index numbers such as the Consumer Price Index rise and fall in points, but points depend on how high the index happens to be. The US Bureau of Labor Statistics shows this with three items in its CPI technical notes:
| Item | Old index | New index | Change in points | Percentage change |
|---|---|---|---|---|
| A | 112.5 | 121.5 | 9 | 8.0% |
| B | 225 | 243 | 18 | 8.0% |
| C | 110 | 128 | 18 | 16.4% |
Items A and B moved by different numbers of points, 9 and 18, yet both rose 8.0%. Items B and C moved by the same 18 points, but C rose 16.4% because it started lower. That is the reason statistics agencies report percentage changes: they can be compared across items, places and years, while points cannot.
Why the way back is a different percentage
A rise of 25.00% takes 100 to 125, but a fall of 25.00% from 125 does not bring you home: it lands on 93.75. The fall you need is 20.00%, because the starting point is now the bigger number.
This catches people out with prices, shares and pay. A share that falls by half needs to double to recover. The result panel shows the reverse percentage for your numbers every time, and the printable tables list it for common changes.
When the starting value is zero or negative
From zero there is no percentage change at all. Going from 0 to 5 is a rise of 5, but dividing by zero has no answer. Many calculators print "Infinity" or an error. This one says the percentage is not defined and shows the absolute change, which is what an analyst would report, often with "n/m" for not meaningful.
From a negative number, the calculator divides by the size of the starting value. That is a common convention, and it keeps a plus sign meaning "went up": from -25 to 25 comes out as +200.00%. A plain spreadsheet formula gives the opposite sign. The size of the percentage still means little, so the result panel shows the absolute change beside it. The guide to negative numbers and zero goes through loss to profit, temperatures and the log change.
Which measure answers your question?
- One value then another, in time order: percentage change, on this page.
- Two values with no before and after, such as two lab measurements: percent difference.
- Two rates, such as interest rates, tax rates or poll shares: percentage points, with the relative change beside them.
- A value after a markup, tax or discount, when you want the value before it: reverse percentage.
- Growth over several years: CAGR. For a month or a quarter turned into a yearly pace: annualized change.
- Several changes in a row: successive changes, because percentages do not add.
- Money over time, when prices also moved: real change after inflation.
The formula in a spreadsheet
With the old value in A2 and the new value in B2, type =(B2-A2)/ABS(A2) and format the cell as Percentage. The ABS makes negative starting values follow the same convention as this calculator. To show "n/m" instead of an error when the old value is zero, wrap it: =IF(A2=0,"n/m",(B2-A2)/ABS(A2)) (decimal comma locales: =IF(A2=0;"n/m";(B2-A2)/ABS(A2))).
The result panel writes the formula with your own numbers too, in the comma form used in the US, UK, Canada and Australia, and in the semicolon form that spreadsheets use where the decimal mark is a comma. There is more in the Excel guide and the Google Sheets guide.
Decimal commas, grouping and rounding
You can type 1,234.5 or 1.234,5. The decimal mark switch under the calculator sets which is which, and it starts from your browser's language. Spaces and Indian lakh grouping, such as 1,00,000 for one hundred thousand, are read correctly.
Results are shown to two decimal places and computed in full precision first. That matters more than it sounds: in raw computer arithmetic, the change from 0.1 to 0.3 comes out a hair under 200%. Rounding once, at the end, shows the clean 200.00%. The methodology page lists every rule and all 43 test cases.
Questions people ask
Is percent change the same as percentage change?
Yes. "Percent change" is more common in the US and "percentage change" elsewhere, and both mean the change divided by the old value, times 100.
Can a percentage change be more than 100%?
An increase can be any size: a 100% increase doubles a value and a 200% increase triples it. A decrease from a positive value stops at -100%, when the value reaches zero, unless the new value is negative.
What is the percentage change from 0?
It is not defined, because you cannot divide by zero. Report the absolute change instead, or write "n/m".
Every calculator and guide
Each tool has one job, its own worked example and its own guide to the mistakes people make with it.
Checked against official worked examples
The engine behind every calculator reproduces the published examples of the US Bureau of Labor Statistics, the Bureau of Economic Analysis, the UK Office for National Statistics, Microsoft and Google before any page is built. If a single case fails, the site does not build. How we calculate and test, who runs this site, or report a correction.