Table of Contents
To apply a percentage increase or decrease in Excel, first select the cells that you want to apply the percent change to. Then, go to the “Home” tab and click on the “Number Format” drop-down menu. From there, select “Percentage” and choose the desired percentage format. To increase the values by a certain percentage, enter the percentage increase in a separate cell, and then use the formula “=original value*(1+percentage increase)” in the cell where you want the new value to appear. To decrease the values, use the formula “=original value*(1-percentage decrease)”. Press enter and the new values will be calculated with the applied percentage change.
Apply a Percentage Increase or Decrease in Excel
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.
Additional Resources
The following tutorials explain how to perform other common tasks in Excel:
Cite this article
stats writer (2024). How do I apply a percentage increase or decrease in Excel?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-do-i-apply-a-percentage-increase-or-decrease-in-excel/
stats writer. "How do I apply a percentage increase or decrease in Excel?." PSYCHOLOGICAL SCALES, 30 Jun. 2024, https://scales.arabpsychology.com/stats/how-do-i-apply-a-percentage-increase-or-decrease-in-excel/.
stats writer. "How do I apply a percentage increase or decrease in Excel?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-do-i-apply-a-percentage-increase-or-decrease-in-excel/.
stats writer (2024) 'How do I apply a percentage increase or decrease in Excel?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-do-i-apply-a-percentage-increase-or-decrease-in-excel/.
[1] stats writer, "How do I apply a percentage increase or decrease in Excel?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How do I apply a percentage increase or decrease in Excel?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.