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: