How to Calculate Price Increase Percentage in Excel (3 Ways)

Many companies or business sectors keep their important information in an Excel workbook. They have to perform numerous operations according to their requirements. The sales sector stores the price records for different products in the worksheet. And a lot of time, they have to evaluate the price difference in percentage. The percentage format gives a better understanding of the price changes. The manual calculation for each of the products is an inefficient and tiresome process. In this article, we’ll show you the easy and effective methods to calculate the price increase percentage in Excel.

How to Calculate Price Increase Percentage in Excel: 3 Easy Ways

This article will show the price increment in a percentage format. So, the new price of the products will be greater than the previous one. To illustrate, we’ll use a sample dataset as an example. For instance, the following dataset has 4 products, their old and new prices. Now, you’ll see 3 different procedures to determine the percentage increase in price.

1. Calculate Price Increase Percentage Manually with Simple Formula

In an Excel worksheet, we can create formulas according to our needs using different cell values. We will get the increased price by subtracting the previous price from the new one. But, these values don’t give a clear concept of comparison among all the products. So, it’s necessary to convert them into a percentage format. That’s why the subtracted result needs to be divided by the previous price and then multiplied by 100. Keeping this in mind, we’ll generate a simple formula for calculating the price increase percentage. Therefore, follow the steps below to carry out the operation.


  • First, select cell E5.
  • Then, type the formula below.
  • After that, press Enter to return the value.

Calculate Price Increase Percentage Manually with Simple Formula

  • Use AutoFill to expand the formula and get the percentage increase in the price of all the products.
  • Thus, you’ll get the desired percentage differences.

Calculate Price Increase Percentage Manually with Simple Formula

Read More: How Do You Calculate Percentage Increase or Decrease in Excel

2. Use Excel Formula & Percentage Number Format to Determine Price Increase

In the previous method, we didn’t have to apply the Number format as we multiplied by 100. But, to make the formula more simple, we can avoid the multiplication part. So, learn the following steps to use the formula and percentage format to determine price increases in Excel.


  • Select range E5:E8.
  • Now, go to the Home tab.
  • Next, click the % (Percentage) symbol which you’ll find in the Number section.

  • Afterward, choose cell E5 to type the formula.
  • To get the output, press Enter.
  • Then, use the AutoFill tool.
  • As a result, it’ll return the next values.
  • In this way, you can determine the price increase with a very simple formula.

Read More: How to Calculate Percentage Increase from Zero in Excel

3. Get Price Increase Percentage with VBA in Excel

Sometimes, creating formulas may seem a hassle. In that case, you can always apply the Excel VBA to carry out the necessary operations. This is also a favorite choice for anyone who loves code. Hence, follow the below process to figure out the price increases in a percentage format.


  • Go to the Developer tab first.
  • There, you’ll see the Visual Basic on the left side.
  • Select it.

Get Price Increase Percentage with VBA in Excel

  • As a result, the VBA window will pop out.
  • Here, click Module from the Insert drop-down.

Get Price Increase Percentage with VBA in Excel

  • The Module window will appear.
  • Now, copy the following code and paste it into the Module box.
Sub PriceIncrease()
Dim output As Integer
Dim i As Integer
For i = 5 To 8
output = ((Cells(i, 4).Value - Cells(i, 3).Value) / Cells(i, 3).Value) * 100
Cells(i, 5).Value = output & "%"
Next i
End Sub

Get Price Increase Percentage with VBA in Excel

  • Next, save the code and the file.
  • After that, close the VBA window.
  • Go to your desired worksheet and select Developer Macros.
  • Accordingly, the Macro dialog box will emerge.
  • Then, choose PriceIncrease and press Run.

Get Price Increase Percentage with VBA in Excel

  • At last, the precise price increase percentages will return in the range E5:E8.

Read More: How to Calculate Average Percentage Increase in Excel

Download Practice Workbook

Download the following workbook to practice by yourself.


Henceforth, you will be able to calculate the price increase percentage in Excel following the above-described methods. Keep using them and let us know if you have more ways to do the task. Follow our website for more articles like this. Don’t forget to drop comments, suggestions, or queries if you have any in the comment section below.

Related Articles

<< Go Back to Percentage ChangeCalculating Percentages | Calculate in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Aung Shine
Aung Shine

Aung Shine completed his bachelor’s in Electrical and Electronics Engineering from Bangladesh University of Engineering and Technology. It has been almost 2 years since he joined SOFTEKO and actively working on the ExcelDemy project. Currently he works as a Team Leader where he guides his team members to create technical content. He has published 150+ articles and reviewed 50+ articles. He has also solved various user problems before. He has interests in Data Analysis, Power Query, Advanced Excel,... Read Full Bio

  1. Thank you! I could do the work, but I couldn’t figure out the why. You’re formula on Calculating retail price was very helpful!

Leave a reply

Advanced Excel Exercises with Solutions PDF