How to Add 20 Percent to a Price in Excel (2 Quick Methods)

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.

Formula to Add 20 Percent to a Price in Excel

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

Formula to Add 20 Percent to a Price in Excel

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

Formula to Add 20 Percent to a Price in Excel

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.

Formula to Add 20 Percent to a Price in Excel

  • Type the following formula in Cell D8
=C8*$D$5
  • Then hit the Enter button.

Formula to Add 20 Percent to a Price in Excel

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

Formula to Add 20 Percent to a Price in Excel

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

Formula to Add 20 Percent to a Price in Excel

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.

Formula to Add 20 Percent to a Price in Excel

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

Formula to Add 20 Percent to a Price in Excel

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

Formula to Add 20 Percent to a Price in Excel

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


Similar Readings:


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.

Paste Special to Add 20 Percent to a Price in Excel

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

Paste Special to Add 20 Percent to a Price in Excel

  • At this moment, copy the cells C8:C14.

Paste Special to Add 20 Percent to a Price in Excel

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

Paste Special to Add 20 Percent to a Price in Excel

  • 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

Mithun

Mithun

Hello! I am Md. Sourov Hossain Mithun. Welcome to my profile. Currently, I am working at Exceldemy as an Excel and VBA Content Developer. Excel is amazing software. Here I will post excel related useful articles. I am a graduate of Bangladesh University of Engineering and Technology. I love to learn new things and work with them. Thank you.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo