You can use Excel to increase the price of your product by 10%, or any percentage for that matter. Using Excel will save you time, and you will look good while increasing your prices. In this article, we will show you how to add a percentage increase to the price with an Excel formula.

**Contents**hide

## 📁 Download Excel File

Download the following workbook to practice by yourself.

## Learn to Add Percentage to Price in Excel with Formula Using These 3 Methods

So what does adding a percentage increase to your price actually mean? Suppose you have a product that is priced at 100 USD. You now want to sell the product at a 15% higher price than usual for a variety of reasons. So what would be the new price? That is what we are going to find out in this article. Today we will use an Excel formula in three ways to add a percentage increase to the price. You will also use Excel’s **Paste Special** feature to do the same job. Finally, we will attempt to achieve the result using a **VBA** code. We will use a list of some items whose prices have to be increased by some percentages. I hope these methods make working with Excel easier for you.

**Method 1**

### 1. Using Mathematical Formula

In this article, we will use the following formula to add a percentage increase to the price. If we need to add an **X% **increase to our Old Price, the New Price will be,

In the previous section, we asked you a question about the new price of a product that is priced at 100 USD and increased by 15%. So using this formula, we can find that. If we place 15 in exchange for X in the formula, our New price would be 115 USD. Let’s use this formula in Excel.

**Mathematical Formula**

#### 1.1 Technique 1

We will use the above formula in Excel directly.

**⬇️⬇️ STEPS ⬇️⬇️ **

- First, select your output cell as we selected
**E6**. - Then, type the following formula in the
**Formula Bar**.

**=C6*(1+D6)**

- Press
**Enter**to see the result.

- Use the
**Fill Handle**to tool copy the formula to the rest of the Rows.

**Mathematical Formula**

#### 1.2 Technique 2

We can also use the above formula in the following fashion:

**⬇️⬇️ STEPS ⬇️⬇️**

- First select cell
**E6**. - Next, write the following formula

**=C6+(C6*D6)**

- Press
**Enter**to see the increased price.

- Lastly, use the
**Fill Handle**to get the same result for the rest of the items.

**Mathematical Formula**

#### 1.3 Technique 3

Another way to use the formula is to include a new column in which we will compute the price increase relative to the starting price. Then we will multiply the result by the old price to get the New price.

**⬇️⬇️ STEPS ⬇️⬇️ **

- First, we will create a new column named ‘Total Increased’ and in column
**E6**we will type the following formula.

**=1+D6**

- Press
**Enter**and use the**Fill handle**to get the entire column.

- Again, in cell
**F6**, type the following formula.

**=C6*E6**

- Subsequently, press
**Enter**and use the**Fill Handle**to get the New prices of the entire column.

**📕 Read More: Calculate Discount Percentage Using Formula in Excel**

**Method 2**

### 2. Applying Paste Special

We can also use Excel’s **Paste Special** feature to add a percentage increase to our price.

**⬇️⬇️ STEPS ⬇️⬇️ **

- Start by entering the following formula in cell
**E6**.

**=1+D6**

- Then, press
**Enter**and use**Fill Handle**after that.

- Then, using the keyboard shortcut
**Ctrl + C**, copy all of the Old Prices ranging from**C6:C11**.

- After that, select the output range
**E6:E11**and right-click to get the context menu. Here, select**Paste Special**.

- A dialog window for
**Paste Special**will open. In the**Operation**section, choose**Multiply**, then click**OK**.

As a result, the chosen column will now contain all of the updated prices.

**📕 Read More: ****5 Easy Methods to Add 10 Percent to a Number in Excel**

**Method 3**

### 3. Using VBA Code

We can achieve the same goal using a **VBA **code if you want. To write your code, you need to first access the** Developer** tab. Click here to see **how to access the Developer tab**. Let’s see how we can use the coolest version of Excel to add the percentage increase to our price.

**⬇️⬇️ STEPS ⬇️⬇️ **

- First, on the left side of the Ribbon, on the
**Developer**Tab, click**Visual Basic**.

- A window (Microsoft Visual Basic for Applications) will open, and we will enter our code here. Select
**Module**from the**Insert**.

- Copy the following formula in the white module.

```
Sub add_percentage_to_price()
Dim Percentage As Long
With ThisWorkbook.Worksheets("Method 3")
Percentage = .Cells(Rows.Count, "C").End(xlUp).Row
.Range("E6:E" & Percentage) = "=C6*(1+D6)"
End With
End Sub
```

- Finally, press
**F5**to see the entire column showing your increased price.

In the **Rows. Count**, we gave column **C** because that’s where Old Prices are and in the **Range** property, we are telling Excel three things. First, which Row to start from, second, which Column to print our results; and finally, to calculate as long as it gets the Old prices. After that, we wrote our formula to calculate the New Prices.

**📕 Read More: 3 Quick Ways to Add 20 Percent to a Price in Excel**

## 📄 Important Notes

`🖊️`

In the Increase Percentage column, you need to edit the **Number format** of the column to show the percentages.

`🖊️`

Ensure that some of the aforementioned formulas include parentheses. Excel conducts multiplication operations prior to addition or subtraction. Some of the formulas mentioned above would thus provide incorrect results. Pass the second portion of the formula in parentheses to obtain the precise result.

## 📝 Takeaways from This Article

`📌`

We explained the formula for the percentage increase in this article.

`📌`

How the users will use the formula in Excel was explained briefly.

`📌`

We also explained how the **Paste Special** feature could be useful here.

`📌`

Finally, a VBA code has been provided to conduct the operation.

## Conclusion

We have come to the conclusion of our article. I hope that after reading this article, you can easily add a percentage increase to your price in Excel. If you have any questions, feel free to comment below. I will try to answer them as soon as possible. Have fun using Excel, and you can visit **Excelden.com** for more tutorials. Thank You.

## Related Articles

**How to Calculate Cumulative Percentage in Excel****2 Ways to Calculate Bacterial Growth Rate in Excel****Calculate Percentage Change with Negative Numbers in Excel****4 Simple Ways to Calculate Forecast Accuracy Percentage in Excel****Calculate Percentage in Excel Based on Conditional Formatting****4 Easy Ways to Calculate Percentage in Excel Based on Cell Color**