30 Advanced Excel Tips for 2026

Excel Champs / Excel Formulas List / How to Add-Subtract Percentage from a Number in Excel (Formula)
By Puneet Gogia (Microsoft MVP)

How to Add-Subtract Percentage from a Number in Excel (Formula)

30+ Advanced Excel Tips for 2026

No spam. Only Excel Stuff. God Promise. 😊

To increase a number by a percentage, multiply it by 1 plus that percentage: =A1*(1+10%) adds 10%, turning 100 into 110. To decrease, subtract instead: =A1*(1-10%) gives 90. You can write the percentage as 10% or as 0.1 — they’re the same value to Excel, since a percentage is just a decimal with percentage formatting applied.

To take the rate from a cell rather than typing it in, use =A1*(1+B1) with 10% in B1, which lets you change the rate without editing the formula. Two things worth knowing. Adding 10% and then subtracting 10% doesn’t return you to the original number — 100 becomes 110, then 99 — because the second calculation works on the larger base.

And to find just the amount of the increase rather than the new total, use =A1*10%, which returns 10 rather than 110.

Let’s say you have a value, and you want to add or subtract a percentage of it. For example, you want to add 10 percent to 100, or you want to deduct 10 percent from it. It’s a quick and easy calculation that you can do with a formula in Excel.

add-subtract-percentage-from-number

Below are the formulas that you can use to increase or decrease a numeric value by a particular percentage.

  • To Increase: =original_value*(100%+increase_percentage%)
  • To Decrease: =original_value*(100%-decrease_percentage%)

In this tutorial, we will learn to write these formulas.

Formula to Add or Increase a Value by a Percentage

You can use the below steps:

  1. First, in a cell, refer to the cell where you have the original value.
  2. After that, enter the asterisk operator for multiplication.
  3. Now, enter the opening parenthesis and then enter “100%”.
  4. Next, enter the addition operator and 10%, which is the percentage you want to increase the value by.
  5. In the end, enter the closing parenthesis and hit Enter to get the result.
add-a-value-by-percentage
=A1*(100%+10%)

The moment you hit enter, it will return the value by increasing it to 110%.

value-added-by-percentage

You can also write the formula in the following way, where instead of 100%, you use 1, and for the increase percentage, you use a decimal value.

other-way-of-using-formula-to-add-a-value-by-percentage
=A1*(1+0.1)

Formula to Subtract or Decrease a Value by a Percentage

You can use the below steps to write this formula:

  1. First, enter = in a cell and refer to the cell with the original value.
  2. After that, enter the asterisk operator and the opening parenthesis, and enter 100%.
  3. Next, use the subtraction sign to deduct and enter the percentage value that you want to decrease.
  4. In the end, enter the closing parenthesis and hit Enter to get the result.
formula-to-subtract-value-by-percentage
=A1*(100%-10%)

The moment you hit enter, it will return a new value with a decrease.

value-decreased-by-percentage

And you can also write the formula in the following way, where you use 1 instead of 100%, and .1 to specify 10%.

other-way-formula-to-decrease-value
=A1*(1-0.1)

How Do These Formulas Work?

To understand these formulas, you need to split them into three parts:

  1. Original Value
  2. 100% or 1
  3. Increase and Decrease (In Percentage or Decimal)

The original value is multiplied by 100% (the full value) plus or minus the change. So, if you want to decrease a value by 15 percent, you just need to use 15% with the minus operator, like 100%-15%, or you can also use 1-0.15.

A percentage value is a number formatted as a percentage in Excel. When you enter 100% in a cell, Excel treats it as a 1 and formats it with the percentage. That’s why you can use 1 or 100% in the formula. And to specify the increase, you can use a decimal value or a percentage value.

Use the Percentage from a Cell

Instead of typing 10% in the formula, you can enter the percentage in a cell (like B1) and refer to it. This way, you can change the percentage without editing the formula:

=A1*(1+B1)
=A1*(1-B1)

If you want to apply the same percentage to a whole column of values, lock the percentage cell with dollar signs, so it doesn’t change when you drag the formula down:

=A1*(1+$B$1)

Get the Original Value Back

If you have a value that already includes an increase, like a price of 110 with 10% added, divide it by 100% plus the percentage to get the original value:

=A1/(1+10%)

With 110 in A1, this returns 100. Don’t subtract 10% from 110 for this, as 10% of 110 is 11, and you would get 99 instead of 100.

Common Mistakes

  • Subtracting the percentage directly: =A1-10% doesn’t take 10 percent off the value. Excel reads 10% as 0.1, so with 100 in A1 you get 99.9.
  • Adding and then subtracting the same percentage: increasing 100 by 10% gives 110, and decreasing 110 by 10% gives 99, not 100.
  • A percentage stored as a whole number: if B1 holds 10 instead of 10%, =A1*(1+B1) multiplies the value by 11. Format the cell as a percentage or divide it by 100.

Frequently Asked Questions

How do I add a percentage to a whole column without a formula?

Enter 110% (or 1.1) in an empty cell and copy it. Select the values, then go to Home ➜ Paste ➜ Paste Special, choose Multiply and click OK. Excel changes the values in place.

Does the formula work with negative numbers?

Yes, but keep in mind that increasing -50 by 10% gives -55, which moves the value further from zero.

How do I find the percentage change between two values?

Subtract the old value from the new one and divide by the old value, then format the result as a percentage:

=(B1-A1)/A1
Puneet Gogia

Written by

Puneet Gogia

Microsoft MVP — Excel · Founder, Excel Champs

Twelve years of teaching Excel, and a decade before that using it as a data analyst. Every tutorial here is written from a file I actually built.

3M+ readers helped
1,000+ tutorials written
Since 2015 teaching Excel

Leave a Comment