Adding or subtracting a percentage is a very common task in Excel for business or any other purpose. There are many ways to do it but this article will provide you with the 2 quickest methods to add 20 percent to a price in Excel.

**Download Practice Workbook**

You can download the free Excel template from here and practice on your own.

**2 Ways to Add 20 Percent to a Price in Excel**

To explore the methods we’ll use the following dataset that represents some cloth items’ prices of a cloth store.

**1. Use Formula to Add 20 Percent to a Price in Excel**

In our very first method, we’ll use 3 formulas to add 20 percent to a price in Excel. For that, I have placed the percentage in **Cell D4**. And to show the new price I have created a new column named ‘**New Price**’.

**Formula 1:**

- In
**Cell D7**write the following formula-

`=C7*(1+$D$4)`

- Or you can type the formula like this-

`=C7+C7*$D$4`

- Later, press the
**Enter**button to get the output.

- Finally, drag down the
**Fill Handle**icon to copy the formula for the other cells.

Then you will get all the new prices added by 20 percent.

**Formula 2:**

Now we’ll use another formula that will give you the same result. That’s another format of the previous formula. After adding 20 percent, it will be 120% of the old price overall. So here we’ll multiply by 120% directly with the old price. So I have placed 120% in **Cell D5** to use the reference.

- Type the following formula in
**Cell D8**–

`=C8*$D$5`

- Then hit the
**Enter**button.

- Finally, to get all the other new prices, drag down the
**Fill Handle**icon over the cells**D9:D14**.

Have a look that we have got the same output as before.

**Formula 3:**

Now we’ll add 20 percent to a price in a different way using **the SUM function**. Firstly, we’ll calculate the increased amount then we’ll sum for new price. For that, I have added a new column for the increased amount. Now let’s calculate the increased amount.

- Type the following formula in
**Cell D7**–

`=C7*$E$4`

- Hit
**Enter**button.

- Then drag down the
**Fill Handle**icon to get the other increased amount.

Here’s all the increased amount for each item.

Now we’ll calculate the new price using the **SUM **function.

- Write the following formula in
**Cell E7**to get the new price for the first item-

`=SUM(C7:D7)`

- Later, press the Enter button for the result.

- After that, to get the other new prices, just drag down the
**Fill Handle**icon through the cells below.

Then soon after you will get all the new prices after adding 20%.

**Related Content: How to Add 10 Percent to a Number in Excel (2 Easy Methods)**

**Similar Readings:**

**How to Calculate Percentage Increase from Zero in Excel (4 Methods)****Calculate Average Percentage Increase for Marks in Excel Formula****How to Use the Exponential Growth Formula in Excel (2 Methods)****Calculate Dividend Growth Rate in Excel (3 Methods)****Percentage Formula in Excel (6 Examples)**

**2. Apply Paste Special to Add 20 Percent to a Price in Excel**

Instead of using a formula, we can add any percentage to a value in a very smart way by using the **Paste Special** command.

**Steps:**

- First, type the following formula in
**Cell D8**which is containing the increased percentage-

`=$D$5`

- Then hit the
**Enter**button.

- After that drag down the
**Fill handle**icon to copy the same formula for the rest of the cells.

- At this moment, copy the cells
**C8:C14**.

- Later, select
**Cell D8**and**right-click**your mouse. - Select
**Paste Special**from the**context menu**and then you will get a dialog box. - Or you can press
**Ctrl+Alt+V**to open the**Paste Special**dialog box directly.

- Mark
**All**from the**Paste**section and**Multiply**from the**Operation**section. - Finally, just press
**OK**to finish.

Now see the output, we are done with the operation.

**Read More:** **How to Add Percentage to Price with Excel Formula (2 Ways)**

**Things to Remember**

- Make sure you have used
**Absolute Reference**where needed. - Make sure you have pressed the right shortcut key-
**Ctrl+Alt+V**to open the**Paste Special**command**.**

**Conclusion**

I hope the procedures described above will be good enough to add 20 percent to a price in Excel. Feel free to ask any question in the comment section and please give me feedback.

**Related Articles**

**Calculate Percentage Using Absolute Cell Reference in Excel (4 Methods)****How to Calculate Reverse Percentage in Excel (4 Easy Examples)****Apply Percentage Formula in Excel for Marksheet (7 Applications)****How to Calculate Net Profit Margin Percentage in Excel****Calculate Percentage in Excel Based on Cell Color (4 Methods)**