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

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

Method

### 1. Add Percentage of Price Using Formula 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.

Using Formula

#### 1.1  With Parentheses

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.

=C6*(1+20%)

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

Formula 2

#### 1.2 Without Parentheses

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.

=C6+C6*20%

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

Method 2

### 2. Using Absolute Cell Reference

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.

Example 1

#### 2.1 Adding 20% in Percentage Format

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.

=1+20%

• Then insert the following formula in cell D9.

=C9*\$C\$6

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

Example 2

#### 2.2 Adding 20% in Decimal Format

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.

=1+20%

• Then insert the following formula in cell D9.

=C9*\$C\$6

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

Method 3

### 3. Using SUM Function

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.

=SUM(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.

## 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:

=C6*20%

## 📄 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.

📌  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

(Visited 75 times, 1 visits today)

#### Md Shamse Tabrej

Hi, I'm Shamse Tabrej. I'm an admirer of Excel who enjoys sharing and solving problems in Excel. I make an effort to investigate all of the choices so that I may point readers toward the most viable solutions. Both the globe and its problems are boundless. Let's assist one another in developing. Reader questions and suggestions are most welcome.

We will be happy to hear your thoughts