How to Calculate the Price Increase in Percentage in Excel – 3 Methods

The sample dataset showcases 4 products, their old and new prices. To determine the percentage increase:

Method 1 – Calculate the Price Increase in Percentage Manually with a Simple Formula

STEPS:

• Select E5.
• Enter the formula below.
`=((D5-C5)/C5)*100`
• Press Enter to see the result.

• Drag down the Fill Handle to AutoFill the formula and get the percentage increase for all products.
• This is the output.

Method 2 – Use an Excel Formula and the Percentage Number Format to Determine the Price Increase

STEPS:

• Select E5:E8.
• Go to the Home tab.
• Click the % (Percentage) symbol in Number.

• Enter the formula in E5.
`=(D5-C5)/C5`
• Press Enter.
• Drag down the Fill Handle to see the result in the rest of the cells.
• This is the output.

Method 3 – Get the Price Increase in  Percentage with VBA in Excel

STEPS:

• Go to the Developer tab.
• Select Visual Basic.

• In the VBA window, select Insert.
• Choose Module.

• Enter the following code into the Module.
``````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``````

• Save the code and the file.
• Close the VBA window.
• Go to the worksheet and select Developer > Macros.
• In the Macro dialog box, choose PriceIncrease and click Run.

• The price increase in percentage will be returned in E5:E8.

Related Article

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

Get FREE Advanced Excel Exercises with Solutions!
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