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 two quickest methods to add 20 percent to a price in Excel.
How to Add 20 Percent to a Price in Excel: 2 Easy Ways
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 three 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, plus 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 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 the 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 the 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 Subtract a Percentage in Excel
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 contains 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.
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.
Download Practice Workbook
You can download the free Excel template from here and practice on your own.
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
- Excel Formula to Add Percentage Markup
- How to Do Sum of Percentages in Excel
- How to Add Percentage to Price with Excel Formula
- How to Subtract a Percentage from a Price in Excel
- How to Subtract 10 Percent in Excel
- How to Use Excel Formula to Calculate Percentage of Grand Total
- How to Add 10 Percent to a Number in Excel
- How to Add 15 Percent to a Price in Excel
<< Go Back to Add Percentage to a Number in Excel | Calculating Percentages in Excel | How to Calculate in Excel | Learn Excel
Get FREE Advanced Excel Exercises with Solutions!