Combine two percent changes
Turn two 10% increases into 21%, not 20%.
What you'll make

The formula

| Number | Part | What it does | Result 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 | -1 | Takes 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))-1How to use it
Yellow bar at the top? Click Enable Editing.
- See it work. The Example tab shows 20 made-up examples with the formula already in.
- 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.
- 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%.
Microsoft's help: Calculation operators in Excel
OTHER ROUTES YOU MIGHT LIKE

Calculate percentage change
100 to 120 → 20%
Get the template →
Calculate a percentage-point difference
10% to 15% → 5.00 percentage points
Get the template →
Add a percent increase to a number
100 with a 10.0% increase → 110
Get the template →
Merge a few test letters before the whole mailing
Whole mailing → records 2 to 4 only
Take this route →