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.

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:
- First, in a cell, refer to the cell where you have the original value.
- After that, enter the asterisk operator for multiplication.
- Now, enter the opening parenthesis and then enter “100%”.
- Next, enter the addition operator and 10%, which is the percentage you want to increase the value by.
- In the end, enter the closing parenthesis and hit Enter to get the result.

=A1*(100%+10%)
The moment you hit enter, it will return the value by increasing it to 110%.

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.

=A1*(1+0.1)
Formula to Subtract or Decrease a Value by a Percentage
You can use the below steps to write this formula:
- First, enter = in a cell and refer to the cell with the original value.
- After that, enter the asterisk operator and the opening parenthesis, and enter 100%.
- Next, use the subtraction sign to deduct and enter the percentage value that you want to decrease.
- In the end, enter the closing parenthesis and hit Enter to get the result.

=A1*(100%-10%)
The moment you hit enter, it will return a new value with a decrease.

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

=A1*(1-0.1)
How Do These Formulas Work?
To understand these formulas, you need to split them into three parts:
- Original Value
- 100% or 1
- 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
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.