Undo a percent increase

Turn 110 back into 100 when it rose by 10%, typed as 0.1.

What you'll make

In Excel: 110 after a 0.1 (10%) increase becomes 100.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1A8The 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.

  1. See it work. The Example tab shows 20 made-up examples with the formula already in.
  2. 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.
  3. 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.