Undo a percent decrease
Turn 90 after a 10% decrease back into 100, and flag a 100% decrease.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | B8=1 | Checks if the decrease is 100%. | No |
| 2 | "Review 100% decrease" | What the cell says for a 100% decrease. | Not used for row 8 |
| 3 | A8/(1-B8) | Divides the amount by what was left, 90%. | 100 |
| 4 | IF( … ) | Uses part 2 for a 100% decrease, otherwise part 3. | 100 |
After a 100% decrease everything is gone, so the original can't be worked out. Nothing is rounded.
=IF(B8=1,"Review 100% decrease",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 amounts into column A and decreases into column B of the Template tab. The originals fill in by themselves.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
Paste decreases as rates, like 0.1 for 10%. A pasted 10 would mean 1000% and give -10.
Microsoft's help: IF function
OTHER ROUTES YOU MIGHT LIKE

Combine two percent changes
10% then 10% increase → 21%
Get the template →
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 →
Merge a few test letters before the whole mailing
Whole mailing → records 2 to 4 only
Take this route →