Combine two percent changes

Turn two 10% increases into 21%, not 20%.

What you'll make

In Excel: 10% then 10% increase becomes 21%.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1(1+A8)Adds the first change to 1, so 10% becomes 1.1.1.1
2(1+B8)Adds the second change to 1 the same way.1.1
3-1Takes 1 off what the two multiply to.0.21, shown as 21%

The * multiplies part 1 by part 2: 1.1 times 1.1 is 1.21. Adding the rates would give only 20%.

=((1+A8)*(1+B8))-1

How to use it

Yellow bar at the top? Click Enable Editing.

  1. See it work. The Example tab shows 20 made-up examples with the formula already in.
  2. Use your own numbers. Paste first changes into column A and second changes into column B of the Template tab. The combined changes fill in by themselves.
  3. Move them into your letter. Copy the results. Then use Paste Special and choose Values.

Before you send

Paste changes as rates or percents, like 0.1 or 10%, with a minus for a fall. A pasted 10 means 1000%.