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**.

**Table of Contents**hide

## Download Practice Workbook

Download the following workbook to practice by yourself.

## 3 Easy Ways to Calculate Price Increase Percentage in Excel

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 multiply 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.

**STEPS:**

- First, select cell
**E5**. - Then, type the formula:

`=((D5-C5)/C5)*100`

- After that, press
**Enter**to return the value.

- Subsequently, use
**the AutoFill tool**to get the percentage increase in the price of all the products. - Thus, youâ€™ll get the desired percentage differences.

**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** Formula **&** Percentage Number Format **to **Determine Price Increases **in **Excel**.

**STEPS:**

- Firstly, select the 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:

`=(D5-C5)/C5`

- Consequently, 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 (4 Methods)**

**Similar Readings**

**How to Calculate Percentage Change with Negative Numbers in Excel****Calculate Price Per Pound in Excel (3 Easy Ways)****How to Show Percentage Change in Excel Graph (2 Ways)****Calculate Weighted Average Price in Excel (3 Easy Ways)****How to Calculate Percentage Decrease in Excel (2 Methods)**

### 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.

**STEPS:**

- Go to the
**Developer**tab first. - There, youâ€™ll see the
**Visual Basic**on the left side. - Select it.

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

- Consequently, 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
```

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

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

**Read More:** **How to Calculate Average Percentage Increase in Excel**

## Conclusion

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 **the ExcelDemy** 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

**How to Calculate Production Cost in Excel (3 Effective Ways)****Calculate Average Price in Excel (7 Useful Methods)****How to Calculate Selling Price Per Unit in Excel (3 Easy Ways)****Calculate Average Percentage Increase for Marks in Excel Formula****How to Calculate Average Percentage Change in Excel (3 Simple Ways)****Calculate Discount Price in Excel (4 Quick Methods)****How to Calculate Salary Increase Percentage in Excel**

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!

Dear

Jamie,You are most welcome.

Regards

ExcelDemy