Calculate Percentage Increase in Excel & Google Sheets
In this Article
In this tutorial, we will learn how to increase a number by percentage in Excel & Google Sheets.
Percentage Increase Formula
To Calculate a percentage increase or increase a number by a specified percentage, simply multiply that number by 1 plus the percentage increase.
For example, if the product’s value has increased by 15% from its last month value (which was $250), then the new value of the product will be calculated by the following formula:
After calculation, the new value of the product is $287.50.
We can generalize the formula to calculate the percentage increase as:
Increase Product Prices by Specific Percentages
Let’s that you want to increase your product prices by certain percentages. The old prices of the products and their respective increase percentages are mentioned in the table below.
We have the old prices of the products and now to calculate the new prices we are simply going to apply the percentage increase formula in cell D3.
To help you better understand the formula, we have divided the above formula into three simple steps:
In the above table, we have the old prices of products, and their respective percentage increases. In the first step, we are going to add 1 to the percentages.
Now that we have the correct percentages, we are going to multiply these percentages with their respective old prices. This will give us our new prices with the percentage increase.
Apply Percentage Increase to all Products
Let’s that you want to increase all your product prices by 5%. For this, you’ll have to apply the percentage increase formula.
As all the product prices need to be increased by 5%. So we going to use absolute reference for the percentage increase cell F2. To fix this cell (F2), we have to select the cell F2 in the formula bar and press the F4 key to make it look like $F$2.
Calculate the Percentage Increase in Google Sheets
The formula to calculate the percentage increase works exactly the same in Google Sheets as in Excel: