Undo a percent decrease

Turn 90 after a 10% decrease back into 100, and flag a 100% decrease.

What you'll make

In Excel: 90 after a 10% decrease becomes 100.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1B8=1Checks if the decrease is 100%.No
2"Review 100% decrease"What the cell says for a 100% decrease.Not used for row 8
3A8/(1-B8)Divides the amount by what was left, 90%.100
4IF( … )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.

  1. See it work. The Example tab shows 20 made-up examples with the formula already in.
  2. Use your own numbers. Paste amounts into column A and decreases into column B of the Template tab. The originals fill in by themselves.
  3. 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