How to Apply a Percent Increase or Decrease to Values in Excel?

Excel is a tool that is used by accounting professionals for financial data analysis. However, it can be used by anyone for various purposes. A cell, a rectangular block (intersection of rows and columns), is used to enter a single unit of the data. This tool is used to get insights from the data using graphs (for visual analysis) or formulas (for trend analysis) etc. Let’s learn how can we calculate a percentage increase of numbers in excel. The percentage means the proportion per hundred (out of 100). It is represented with the symbol ‘%’. Percentage = (Numerator/Denominator) × 100. For example, a 20% increase in 100 will give 120.

Applying a Percent Increase or Decrease to Values in Excel

The mathematical formula to calculate value after percentage increase is given below,

Total value = value(1 + (percentage increase/100)

For example, a 20% increase in 100 will be calculated as:

Final value = 100(1 + (20/100))

= 100(120/100)

= 120

Calculation using Excel

We can use the following formula in excel to calculate the final value after a percentage increase:

= cell_value1 * ( 1+ cell_value2)

cell_value1: It indicates the cell consisting of original value.

cell_value2: It indicates the cell containing percentage value.

Example:

Output:

Percentage increase

For purpose of demonstration, we will use the following table in which the annual salary of different individuals is given along with the percentage of increment received. We will use the percentage increase formula to find out their final annual income after the increment.

Step 1: Use the formula

Step 2: Press Enter

Step 3: Drag the fill handle over to the data range.

Output:

Percentage Decrease

For percentage decrease, we can use the following formula:

 = cell_value1 * ( 1- cell_value2)

cell_value1: It indicates the cell consisting of original value.

cell_value2: It indicates the cell containing percentage value.

For the purpose of demonstration, we will use the following table in which the value of the different products is given along with the percentage discount to be given on the products. We will use the percentage decrease formula to find out their final value after the discount.

Step 1: Use the formula

Step 2: Press Enter

Step 3: Drag the fill handle over to the data range.

Output: