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 to Calculate Discount Price in Excel (4 Quick Methods)**

**Similar Readings**

**How to Calculate Selling Price from Cost and Margin in Excel****Calculate Price Per Pound in Excel (3 Easy Ways)****How to Calculate Coupon Rate in Excel (3 Ideal Examples)****Calculate Retail Price in Excel (2 Suitable Ways)****How to Calculate Weighted Average Price in Excel (3 Easy Ways)**

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

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

## 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 Selling Price in Excel (4 Easy Methods)****How to Calculate Variable Cost Per Unit in Excel (with Quick Steps)****Calculate Bond Price in Excel (4 Simple Ways)****How to Calculate Projected Cost in Excel (4 Effective Ways)**