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)