Calculate Percentage Increase in Excel & Google Sheets

In this tutorial, we will learn how to increase a number by percentage in Excel & Google Sheets.

Percentage Increase Excel

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:

=$250*(1+15%)

=$250*(115%)

=$287.5

After calculation, the new value of the product is $287.50.

General Formula

We can generalize the formula to calculate the percentage increase as:

=number*(1+percentage_increase)

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.

Percentage Increase Example Data

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.

=B3*(1+C3)

Percentage Increase Example 1

To help you better understand the formula, we have divided the above formula into three simple steps:

Step 1

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.

=(1+C3)

Percentage Increase Example step 1

Step 2

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.

=B3*D3

Percentage Increase Example Step 2

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.

=B3*(1+$F$2)

Percentage Increase Example 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:

Percentage Increase Google Sheets

Excel Practice Worksheet

Practice Excel functions and formulas with our 100% free practice worksheets!

  • Automatically Graded Exercises
  • Learn Excel, Inside Excel!