Sometimes we may want to increase the price by a certain percentage. It’s quite easy to change the price by a certain percentage in **Excel**. Here in this article, we will show 2 easy methods to add 15 percent to a price in **Excel**.

**Table of Contents**hide

## Download Practice Workbook

You can download the practice workbook from here.

## What Does Adding Percentage to a Price Mean?

Suppose the initial price of a product is **50$. **Increasing it by **15%** means we will add **0.15** times the price with it which will be **57.5$ **(**50+50*0.15**).

## 2 Easy Methods to Add 15 Percent to a Price in Excel

We can** add a specific percentage to a price** quite simply in Excel. Here we will show 2 easy and simple methods to add 15 percent to a price in Excel. We can use a dataset like the following which includes some products with their initial price.

### Method 1: Apply Excel Formula to Add 15 Percent to a Price

In this method we will apply different formulas to add 15 percent to a price. The steps are described with each formula.

**Formula 1:**

- First, enter the following formula in the cell where we want to see the increased price. In our case the cell is
**D7**.

`=C7*(1+$C$4)`

- After that, press
**Enter**. - Then, we will use the
**Fill Handle**to copy the formula in the cells below.

- We can see the final price which is
**15%**more than the initial price.

**Formula 2:**

- Another way is to multiply the number by
**115%**. To do that we just have to add**100%**with the original percentage change (**15%**) in cell**C4**.

- After that, we write the following formula in the 1st cell of the final price and hit
**Enter**. In our case the cell is**D7**.

`=C7*$C$4`

- We use the
**Fill Handle**to copy the formula to the cells below.

- Here, we can see the final prices which are
**15%**more than the initial prices.

**Formula 3:**

- We can also calculate the increased amount first then add the amount to the initial price. For calculating the change amount, we write the following formula in cell
**D7**.

`=C7*$C$4`

- Next, hit
**Enter**. - Copy the formula in the following cell using the
**Fill Handle**.

- Afterwards we have to add the change amount to the initial price. write the following formula in the
**E7**cell to get the final price.

`=SUM(C7:D7)`

- Then press
**Enter**and use the**Fill Handle**to copy the formula in the rest cells.

- We can see the final prices which have increased by
**15%**.

**Formula 4:**

- Instead of
**percentage**we can also take the equivalent decimal value to do the calculation. We calculate the change amount first by writing the following formula in cell**D7**and pressing**Enter**from the keyboard.

`=C7*$E$4`

- We have to copy the formula in the below cells using
**Fill Handle**.

**$E$4**fixed cell contains the equivalent decimal value of the percentage.

- Now we write the following formula in cell
**E7**to add the change amount with the initial price.

`=SUM(C7:D7)`

- Use the
**Fill Handle**to copy the formula in the following cells.

- Hurrah! We can see the increased final Price.

**Read More:**** How to Add 20 Percent to a Price in Excel (2 Quick Methods)**

### Method 2: Add 15 Percent to a Price Using Paste Special

We can also use the **Paste Special **option of Excel to add **15% **to a price. The steps are given below.

- We will write any of the following formulas in cell
**D8**and hit**Enter**.

`=$C$4`

Or,

`=$C$5`

- Now, copy the formula in the cells below by double-clicking the green arrow sign.

**$C$4**cell contains the percentage value and the

**$C$5**cell contains the decimal equivalent value.

- Next, we have to select and copy the cells having initial prices (
**C8:C11**). We can copy by right click or using the keyboard shortcut**Ctrl + C**. - Then select cell
**D8**. - Afterwards we use
**Paste Special**by right click or by keyboard shortcut**Ctrl + Alt + V**. - In the
**Paste Special**window, we select**All**and**Multiply**options. - Then press
**OK**.

- Finally, we will see the increased final price like below.

**Read More: ****How to Add 10 Percent to a Number in Excel (2 Easy Methods)**

## Things to Remember

- We can add different percentages to a price by the same procedure. We have to change the percentage only.
- Instead of adding if we want to
**subtract a specific percentage to a price**. We just need to put a negative (**–**) sign before the percentage value. - In some cases, we used absolute cell reference so that the reference doesn’t get changed while copying.

## Conclusion

Adding a percentage to a price may come in handy sometimes. In this article, we have shown 2 easy methods to add **15% **to a price. If you face any problem following the steps, please let us know by commenting. Please visit our site **ExcelDemy **for similar articles.

## Related Articles

**Percentage Formula in Excel (6 Examples)****Calculate Average Percentage in Excel (3 Easy Methods)****How to Use Excel Formula to Calculate Percentage of Grand Total****Calculate Percentage Difference Between Two Numbers in Excel****Apply Percentage Formula for Multiple Cells in Excel (5 Methods)****How to Use IF and Percentage Formula in Excel (2 Easy Ways)****Show One Number as a Percentage of Another in Excel (2 Ways)**