In this tutorial, I will show you how to add a percentage to a product’s price using an excel formula. Luckily, adding percentages to a price is very easy. Let’s assume a product’s price has increased by **20%**. It means in every **$100**, the price has increased by **$20**. Often, we have to calculate the price increase for a product when its piece is raised by a certain percent. Similarly, while offering a discount on a product, we have to calculate the decreased price. So, let’s go through the tutorial.

**Table of Contents**hide

## Download Practice Workbook

You can download the practice workbook that we have used to prepare this article.

## Importance of Cell’s Number Formatting During Percentage Calculation

Before entering a percentage in excel cells, remember you have to change the cell’s **Number** format. For example, if you write **12** in a cell and then apply the ‘**%**’ **Number** format, excel will display the number as **1200%**. Eventually, this will return an error in calculation. So, to get the desired cell **Number** format you may follow the below instructions.

**Steps:**

- Type a decimal number (
**.12**) in**Cell D5**.

- Then go to
**Home**>**Number**group, click on the percent ‘**%**’ symbol.

- As a result, the decimal number will be displayed as a percent.

**Read More:** **How to Calculate Percentage of a Number in Excel (5 Easy Ways)**

## 2 Ways to Add Percentage to Price with Excel Formula

### 1. Add Percentage to Price Applying Simple Formula

Let’s assume, we have a list of grocery items with their old price and price increment percentage. Now, I will add these below percentages to the old prices and hence calculate the new prices.

I have used several formulas to add the percentages. Let’s explore them one by one.

📌 **Formula 1:**

For instance, the old price of the **Whole Grain Pasta** was **$10**. Now the price has increased by **12%**. So, I will add **1** to** 12%**, which results in **112%**. Then I will multiply the older price **$10** with **112%** and get the new price (**$11.20**).

**Steps:**

- Type the below formula in
**Cell E5**and press**Enter**.

`=C5*(1+D5)`

- Then you will get the new price for
**Whole Grain Pasta**. Now, use the**Fill Handle**(**+**) tool to get the new price of the rest of the items.

- As a result, we will get the below result.

**📌 Formula 2:**

Instead of using the previous formula (**Formula 1**), we can use the below formula to add percentages to the old price:

`=C5+C5*D5`

📌 **Formula 3:**

Now I will use **Formula 1 **in two steps. First, I will add **1** to the increased percentage. To do that see the following steps.

**Steps:**

- Type the below formula in
**Cell E5**, hit**Enter**, and use the**Fill Handle**tool to get the formula copied in range**E6:E12**.

`=1+D5`

- Then type the below formula in
**Cell F5**to get the new price and press**Enter**.

`=C5*E5`

- Finally, apply the
**Fill Handle**tool to copy the formula to the rest of the cells and here we get the new prices.

📌 **Formula 4:**

Here, I will multiply old prices with increased percentages to get the increased amount in **USD**. Later, I will apply **the SUM function **to add each old price and increased amount.

**Steps:**

- First, type the below formula in
**Cell E5**, hit**Enter**on the keyboard. Next, use the**Fill Handle**tool to copy the formula to the rest of the cells.

`=C5*D5`

- Then, type the below formula in
**Cell F5**.

`=SUM(C5+E5)`

- Consequently, we will get the new price for the first grocery item. Then copy the formula to the rest of the cells using the
**Fill Handle**tool and get all the new prices.

**Read More:** **How to Apply Percentage Formula for Multiple Cells in Excel (5 Methods)**

**Similar Readings**

**How to Calculate Variance Percentage in Excel (3 Easy Methods)****Calculate salary increase percentage in Excel [Free Template]****How do you Calculate Percentage Increase or Decrease in Excel****Excel formula to calculate percentage of grand total (4 Easy Ways)****Calculate Percentage in Excel VBA (Involving Macro, UDF, and UserForm)**

### 2. Use Excel ‘Paste Special’ Option to Add Percentage to Price

You can use the ‘**Paste Special**’ option of excel to copy a range of cells and thus multiply them with another range. So, now I will apply this technique to add a percentage to a price.

**Steps:**

- In the beginning, type the below formula in
**Cell E5**, press**Enter**, and copy the formula over the range**E5:E12**.

`=1+D5`

- Next, select all the
**Old Price**(range**C5:C12**) and copy them by pressing**Ctrl + C**from the keyboard.

- Then, select the range
**E5:E12**and right-click on it. Click on the**Paste Special**option (see screenshot).

- The
**Paste Special**dialog box will appear. Now, click on**Multiply**from the**Operation**section and press**OK**.

- As a consequence, we will get all the new prices in the selected column.

**Read More:** **How to Calculate Percentage Increase in Excel (Examples with All Criteria)**

## Deduct Percentage from Price

In case you are offering a discount on some products, you have to subtract a certain percentage from the original price. To do that simply subtract the percentage from **1** and then multiply the result with the original price. To illustrate, I have applied discounts on the grocery items of the previous example.

**Steps:**

- Type the below formula in
**Cell E5**at first.

`=C5*(1-D5)`

- Then hit
**Enter**, copy the formula to the rest of the cells using the**Fill Handle**tool and get the new decreased prices.

**Related Content:**** Percentage Formula in Excel (6 Examples)**

## Things to Remember

➤ Make sure you have added parenthesis on some of the above formulas such as **=C5*(1-D5)**. This is because excel performs multiplication operations before subtraction or addition. In that case, some of the above formulas will return the wrong result. So to get the exact result, pass the second part of the formula in parenthesis.

➤ You can bring the **Paste Special **dialog box using the keyboard shortcuts (**Ctrl + Alt + V**).

## Conclusion

In the above article, I have tried to discuss several methods to add a percentage to price with excel formula elaborately. Hopefully, these methods and explanations will be enough to solve your problems. Please let me know if you have any queries.

**Related Articles**

**Calculate Average Percentage in Excel [Free Template+Calculator]****How to Calculate Sales Growth Percentage in Excel (2 Easy Approaches)****Calculate Grade Percentage in Excel (3 Easy Ways)****How to Calculate Growth Percentage Formula in Excel****Calculate Year over Year Percentage Change in Excel (3 Easy Techniques)**