Undo a percent increase
Turn 110 back into 100 when it rose by 10%, typed as 0.1.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | A8 | The amount after the increase, like 110. | 110 |
| 2 | (1+B8) | Adds the rate to 1, so 0.1 becomes 1.1. | 1.1 |
The / divides part 1 by part 2: 110 divided by 1.1 is 100. Taking 10% off 110 would give 99.
=A8/(1+B8)How 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 new amounts into column A and rates into column B of the Template tab. The original amounts fill in by themselves.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
Type rates as 0.1 for 10%. A rate typed as 10 would turn 110 into 10.
Microsoft's help: Calculation operators in Excel
OTHER ROUTES YOU MIGHT LIKE

Undo a percent decrease
90 after a 10% decrease → 100
Get the template →
Combine two percent changes
10% then 10% increase → 21%
Get the template →
Calculate percentage change
100 to 120 → 20%
Get the template →
Merge a few test letters before the whole mailing
Whole mailing → records 2 to 4 only
Take this route →