3 Quick Ways to Add 20 Percent to a Price in Excel

In this article, I’ll demonstrate how to use an Excel formula to add 20 Percent to a price in Excel. Increasing a price by a specified percentage is simple.  Let’s say, as an example, that the price of a product has increased by 20 percent to a price. That works up to a yearly increase of 20 percent increase, or $20, for every $100. Calculating the final price of a product following a price increase expressed as a percentage is essential. It is also important to calculate the exact amount of a discount before applying it to an item. Look at this article for some guidance.

📁 Download Excel File

You can download the practice workbook from here.

Learn to Add 20 Percent to a Price in Excel with These 3 Ways

Below you’ll find a total of 3 simple ways to quickly and easily add 20 percent to a price in Excel.

Let’s pretend we have a list of food goods together with their previous price and the percentage by which it has increased. Now I will estimate the new pricing by adding the percentages shown below to the current prices.

To add the percentages, I’ve used a few different formulae. Let’s look at each one in turn.

The previous price of Rice was $60. There was a 20% price hike. Therefore, I will make 1+20%=120% by adding 20 percent to the price. To calculate the new price, I’ll need to multiply the previous price of $60 by 120%, giving me a total of $72.

⬇️⬇️ STEPS ⬇️⬇️

We’ll use the following dataset, which shows the prices of some grocery items at a super shop, to look at how the methods work.

• write the following formula into cell D6 and hit Enter.

• After that, implement that formula in the cells using the fill handle icon.
• Following that, the figures will rise by 20 percent as seen below.

Instead of the earlier formula, we could perhaps use the one below:

⬇️⬇️ STEPS ⬇️⬇️

We’ll use the following dataset, which shows the prices of some grocery items at a super shop, to look at how the methods work.

• write the following formula into Cell D6 and hit Enter.

• After that, implement that formula in the cells using the fill handle icon.
• Following that, the figures will rise by 20 percent as seen below.

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

In this process, we will use an absolute cell reference for calculating added 20 percent of the price.

What is Absolute Cell Reference?

When copying a formula from one cell to another in Excel, an absolute reference is a cell reference where the column and row coordinates remain constant. To conduct the same computation in each row or column, relative cell references that are copied to many rows or columns change based on their position. The definition of an absolute cell reference, on the other hand, is one that is unaffected by a cell’s movement, copying, or filling. Thus, regardless of where a cell appears in the worksheet, the reference always links back to the same cell. A symbol in the column or row coordinates serves as the indicator.

We will use the total percentage of the final price in percent from this example.

⬇️⬇️ STEPS ⬇️⬇️

We’ll use the following dataset, which shows the prices of some grocery items at a super shop, to look at how the methods work.

• Select the cell C6 to calculate the final price of goods using the following formula and convert it to absolute cell reference by pressing the F4 key.

• Then insert the following formula in cell D9.

• After that, implement that formula in the cells using the fill handle icon.
• Following that, the figures will rise by 20 percent as seen below.

In this example, we will use the total percentage of the final price in decimal form.

⬇️⬇️ STEPS ⬇️⬇️

We’ll use the following dataset, which shows the prices of some grocery items at a super shop, to look at how the methods work.

• Select the cell C6 to calculate the final price of goods using the following formula and convert it to a decimal number.

• Then insert the following formula in cell D9.

• After that, implement that formula in the cells using the fill handle.
• Following that, the figures will rise by 20 percent as seen below.

 Read More: Calculate Percentage in Excel Using Absolute Cell Reference

In this method, we will use the SUM function to estimate the final price of grocery items.

⬇️⬇️ STEPS ⬇️⬇️

We’ll use the following dataset, which shows the prices of some grocery items at a super shop, to look at how the methods work.

• Select the cell E6 and use the following formula to get the sum of the cell range C6:D6.

• After that, implement that formula in the cells using the fill handle.
• Following that, the figures will rise by 20 percent as seen below.

 Read More: 3 Ways to Add Percentage to Price in Excel with Formula

How to Calculate the Percentage of a Number in Excel

Excel makes it easy to find the percentage of a number by multiplying the percentage value by the value you want the percentage of.

To estimate 20 percent of 1550, for instance, multiply 20% by 1550. For instance, enter the formula into any Excel cell, we’ll use the following dataset, which shows the prices of some grocery items at a supermarket to look at how the methods work. for this use the following formula in cell D6:

 Read More: Calculate Percentage Change with Negative Numbers in Excel

📄 Important Notes

🖊️  Verify that you’ve employed Absolute Reference when it was required.

🖊️  Always look for ways that are easy to use in different situations.

🖊️  Every time try to use shortcuts on the keyboard.

📝 Takeaways from This Article

📌  You can calculate the new price after a certain percentage increase in price.

📌  You can calculate the changes in price after a certain percentage increase in price.

Conclusion

I’m hoping the above approaches are sufficient to add 20 percent to a price in Excel. This procedure can be beneficial for businesses since it lessens price swings, which makes it simpler to spot trends without the latency that is typically connected with this process. If you have any questions or comments, please leave them below in the comment box. You can also check  www.ExcelDen.com to explore more Excel-related articles.

Related Articles

• 3 Easy Ways to Calculate Accuracy Percentage 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
• 6 Ways to Forecast Growth Rate in Excel