Take a percent decrease off a number

Turn 100 into 80 with a 20% decrease.

What you'll make

In Excel: 100 with a 20.0% decrease becomes 80.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1A8The amount, like 100.100
2(1-B8)Takes the rate from 1, so 20% becomes 0.8.0.8

The * multiplies part 1 by part 2: 100 times 0.8 is 80. Nothing is rounded.

=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 rates into column B of the Template tab. The new 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 20% or 0.2. A rate pasted as 20 means 2000% and turns 100 into -1900.