Add a percent increase to a number

Turn 100 into 110 with a 10% increase.

What you'll make

In Excel: 100 with a 10.0% increase becomes 110.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1A8The amount, like 100.100
2(1+B8)Adds the rate to 1, so 10% becomes 1.1.1.1

The * multiplies part 1 by part 2: 100 times 1.1 is 110.

=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 10% or 0.1. A rate pasted as 10 means 1000% and turns 100 into 1100.