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

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

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

**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 ⬇️⬇️**

- Select the cell
**C6**to calculate the final price of goods using the following formula

**=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.

** Read More: ****Calculate Percentage in Excel Using Absolute Cell Reference**

**Method 3**### 3. Using SUM Function

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

**⬇️⬇️ STEPS ⬇️⬇️**

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

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

**=C6*20%**

** 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**