Growth over time

Successive percentage change calculator

When one percentage change follows another, the percentages do not add. This calculator chains up to twelve changes and gives the net change, the multiplier, the geometric average per step and the change needed to get back.

  • Net effect of up to twelve changes
  • Geometric average, not the misleading simple average
  • Step-by-step table from any starting value

Examples and sources checked on November 21, 2026.

Net change-1.00%Decrease

These two changes (+10.00%, -10.00%) combine to a net -1.00%. Adding the percentages gives 0.00%, which is wrong because each change applies to the value left by the one before.

Multiplierx0.99
Average per step (geometric)-0.50%
Simple average of the percentages0.00%

Step by step from 100

StepChangeValueNet so far
Step 1+10.00%110+10.00%
Step 2-10.00%99-1.00%

Working

  1. Turn each change into a multiplier: 1.1 x 0.9
  2. Multiply: = 0.99
  3. Minus 1, times 100: -1.00%

Spreadsheet formula Excel and Google Sheets

Put the changes in A2 and A3, typed with the % sign.

Excel 365=PRODUCT(1+A2:A3)-1
Google Sheets=ARRAYFORMULA(PRODUCT(1+A2:A3))-1
With your numbers=(1+10%)*(1-10%)-1

Reverse check

To undo a net -1.00% you need +1.01%: 99 x 1.010101 = 100.

Why percentages do not add

Each change applies to the value left by the one before. A rise of 10% turns 100 into 110. A fall of 10% then takes 10% of 110, which is more than the 10 that was added, and you land on 99. Up 10% then down 10% is a cumulative percentage change of -1.00%, not zero.

  1. Turn each change into a multiplier: 1.1 and 0.9.
  2. Multiply them: 1.1 x 0.9 = 0.99.
  3. Subtract 1 and multiply by 100: -1.00%.

The order does not matter, because multiplication does not care about order. Down then up gives the same result.

Common pairs

ChangesAdded (wrong)Net changeCheck: a + b + ab/100
+10% then -10%0%-1.00%-1.00%
+20% then -20%0%-4.00%-4.00%
+50% then -50%0%-25.00%-25.00%
+10% then +20%+30%+32.00%+32.00%
-20% then +25%+5%0.00%0.00%

The last column is the two-change shortcut taught in many aptitude courses: a + b + ab/100. It agrees with the multiplier method for two changes; for more than two, multiply the multipliers.

Successive percentage change over several years

Suppose a price index rose 12% in the first year, fell 8% in the second and rose 15% in the third. Adding gives +19%. Multiplying gives 1.18496, a net change of +18.50%. The average per year is the geometric average, +5.82%: three years at that steady rate give the same end value. The simple average, +6.33%, does not.

This is the same idea as the CAGR, worked from the yearly changes instead of the start and end values. The BLS makes the point for prices in its factsheet on calculating percent changes: a change over a year is not the sum of the monthly changes.

Losses and the way back

A fall needs a bigger rise to recover, because the rise starts from a smaller base. A fall of 50% needs a rise of 100%. The calculator gives the recovery figure for any chain, and the printable tables list it for common losses. A change of -100% anywhere in the chain wipes the value out, and nothing after it can bring it back.

In a spreadsheet

With the changes in A2 to A4, typed with the percent sign, current Excel accepts =PRODUCT(1+A2:A4)-1. In Google Sheets wrap it so the addition runs across the range: =ARRAYFORMULA(PRODUCT(1+A2:A4))-1. With the numbers typed in, the starting example is =(1+10%)*(1-10%)-1. The geometric average per step is =(1+B2)^(1/3)-1 where B2 holds the net change and 3 is the number of steps.

Questions people ask

Is 10% up then 10% down really a loss?

Yes: 1.1 x 0.9 = 0.99, a net change of -1.00%.

How do I average percentage changes?

Multiply the multipliers, take the root for the number of changes, and subtract 1. That is the geometric average. Averaging the percentages directly overstates growth.