Percentage Change Calculator: Increase, Decrease & CAGR
Find the percent increase or decrease between two numbers, with every step shown. The calculator can also add or take off a percent, find the value before a change, combine several changes in a row, and work out the steady yearly (or monthly) rate between a start and an end value.
Example: +10, +10, -5 means up 10%, up 10% again, then down 5%.
Gives the total change and the steady rate per period that gets you from start to end (compound growth, also called CAGR).
Which Tab Do You Need?
- From A to B: “Sales went from 80 to 100. What’s the percent change?” Answer: +25%.
- Add or take off %: “What’s 250 after a 15% rise?” Answer: 287.5.
- Find the original: “It costs 120 after a 20% increase. What did it cost before?” Answer: 100.
- Changes in a row: “Up 10%, then down 10%. Where does that leave me?” Answer: −1%.
- Over time: “1,000 grew to 1,500 in 5 years. What’s that per year?” Answer: about 8.45%.
Tick My values are already percentages when you’re comparing two rates, such as interest rates. You’ll get the change in percentage points as well.
The Formula
Percentage change = (new − old) ÷ |old| × 100
- Subtract the old value from the new one: 100 − 80 = 20.
- Divide by the old value: 20 ÷ 80 = 0.25.
- Multiply by 100: +25%.
A positive answer is an increase, and a negative answer is a decrease. Saying “a 20% decrease” and writing “−20%” mean the same thing, but pick one style and stick to it. Writing the decrease as +20% in one place and −20% in another is a common source of confusion.
The old value always goes on the bottom, so the order matters. 80 to 100 is a 25% increase, but 100 back to 80 is a 20% decrease. The gap is 20 both times. Only the starting point is different.
Up 50%, Then Down 50%, Isn’t Back to the Start
Because each change is measured against a different starting value, a rise and a fall of the same percent don’t cancel out. 100 up 50% is 150, and 150 down 50% is 75. To undo a change, you need a different percent:
| After a rise of | Undo it with a fall of | After a fall of | Undo it with a rise of |
|---|---|---|---|
| 10% | 9.09% | 10% | 11.11% |
| 20% | 16.67% | 20% | 25% |
| 25% | 20% | 25% | 33.33% |
| 50% | 33.33% | 50% | 100% |
| 100% | 50% |
This is why a share that falls 50% has to double to get back to where it was. The Changes in a row tab shows the running total. For example, up 10% and then down 10% leaves 99 out of every 100, an overall change of −1%.
Finding the Price Before a Discount or Tax
If something costs $68 after 15% off, adding 15% back gives $78.20. That’s wrong, because the 15% was taken from the original price, not from $68. Divide by what’s left instead:
- After 15% off, the price is 85% of the original: $68 ÷ 0.85 = $80.
- With 20% VAT included, £120 is 120% of the price: £120 ÷ 1.2 = £100 before tax. Taking 20% off £120 gives £96, which is too low.
The Find the original tab does this division for you and shows what the wrong method would give.
Change Over Several Years: Don’t Just Divide
If a value grows from 1,000 to 1,500 over 5 years, the total change is +50%. It’s tempting to call that 10% a year, but 10% a year for 5 years would give 1,610.51, because each year’s growth builds on the last. The steady rate that actually gets from 1,000 to 1,500 is about 8.45% a year:
Rate per period = (end ÷ start)^(1 ÷ number of periods) − 1
In finance this is called the compound annual growth rate, or CAGR. A value that doubles in 10 years grew by 100% in total, but only about 7.18% a year.
The Over time tab gives both figures, checks the rate period by period, and works for months or quarters too.
Percent Change, Percentage Points and Percent Difference
These three are easy to mix up:
- Percentage points are a plain subtraction of two percentages. An interest rate going from 4% to 5% is up 1 percentage point.
- Percent change compares that rise with the starting rate. The same move, from 4% to 5%, is a 25% increase. Both statements are true, so say which one you mean.
- Percent difference compares two values when neither one is the starting point, such as two shops’ prices. It divides the gap by the average of the two: 80 and 100 differ by 20 ÷ 90 = 22.22%. The calculator shows this figure in the From A to B tab.
To find a percent of a number, or what percent one number is of another, use the Percentage Calculator.
Negative Numbers, Zero and Small Starting Values
- A negative start. The formula divides by the size of the old value, ignoring its sign. So −25 to 25 is +200%, an increase, and −25 to −50 is −100%, a decrease.
- Falling past zero. 50 to −22 is a change of −144%. A fall of more than 100% means the value went below zero. In cases like this, also report the actual difference, which here is 72.
- A start of zero. There’s no percent change from 0, because it would mean dividing by 0. Give the difference instead: going from 0 to 5 is an increase of 5.
- Small starting values. Going from 1 sale to 3 sales is +200%, while going from 1,000 to 1,030 is +3%. The first is a gain of 2 sales and the second a gain of 30. Give the numbers next to the percent, so a big percent on a small base isn’t mistaken for a big change.
- Scales without a true zero. Celsius and Fahrenheit temperatures don’t work with percent change. 10 °C to 20 °C looks like +100%. The same temperatures in Fahrenheit, 50 °F to 68 °F, give +36%, and in kelvin, the scale that starts at absolute zero, the rise is only about 3.53%. Describe temperature changes in degrees instead.
Percentage Change in Excel or Google Sheets
With the old value in A2 and the new value in B2:
- Percent change:
=(B2-A2)/ABS(A2), then format the cell as a percentage. ABS keeps the sign correct when the old value is negative. - Rate per period:
=(B2/A2)^(1/C2)-1, with the number of periods in C2.
If a cell shows #DIV/0!, the old value is 0, and no percent change exists for that row.
