Table of Contents
In Excel, a percentage increase or decrease can be applied to a value by multiplying the value by 1 + the percentage increase/decrease expressed as a decimal. To calculate a percentage increase, the formula 1 + percentage increase/100 should be used, and to calculate a percentage decrease, the formula 1 – percentage decrease/100 should be used. This formula can be used for calculations such as calculating a new price after a percentage increase or decrease.
You can use the following basic formulas to apply a percentage increase or percentage decrease to values in Excel:
Method 1: Apply Percentage Increase
=A1*(1+B1)
Method 2: Apply Percentage Decrease
=A1*(1-B1)
In both formulas, cell A1 contains the original value and cell B1 is the percentage that we’re increasing or decreasing the original value by.
The following examples show how to use each formula in practice.
Example 1: Apply Percentage Increase to Values
Suppose we have the following list of values in Excel:
We can use the following formula in cell C2 to apply a 25% increase to the value in cell A2:
=A2*(1+B2)
The following screenshot shows how to use this formula in practice:
Each value in column A has been increased by 25%.
For example:
- 10 has been increased by 25% to 12.5.
- 15 has been increased by 25% to 18.75.
- 18 has been increased by 25% to 22.5.
- 20 has been increased by 25% to 25.
Example 2: Apply Percentage Decrease to Values
Once again suppose we have the following list of values in Excel:
We can use the following formula in cell C2 to apply a 10% decrease to the value in cell A2:
=A2*(1-B2)
The following screenshot shows how to use this formula in practice:
Each value in column A has been decreased by 10%.
For example:
- 10 has been decreased by 10% to 9.
- 15 has been decreased by 10% to 13.5.
- 18 has been decreased by 10% to 16.2.
- 20 has been decreased by 10% to 18.
And so on.