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 two easy methods to add 15 percent to a price in Excel.

**Table of Contents**Expand

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

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

We can add a specific percentage to a price quite simply in Excel. Here we will show two 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%**to 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%**higher than the initial prices.

**Formula 3:**

- We can also calculate the increased amount first and then add the amount to the initial price. To calculate 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**.

- Afterward, 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 to 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.

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

We can also use the **Paste Special **option in 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 with initial prices (
**C8:C11**). We can copy by right-clicking or using the keyboard shortcut**Ctrl + C**. - Then select cell
**D8**. - Afterward, 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.

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

**Download Practice Workbook**

You can download the practice workbook from here.

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

## Related Articles

- Excel Formula to Add Percentage Markup
- How to Do Sum of Percentages in Excel
- How to Add Percentage to Price with Excel Formula
- How to Add 20 Percent to a Price in Excel
- How to Subtract a Percentage in Excel
- How to Subtract 10 Percent in Excel

- How to Use Excel Formula to Calculate Percentage of Grand Total
- How to Add 10 Percent to a Number in Excel

**<< Go Back to Add Percentage to a Number in Excel | Calculating Percentages in Excel | How to Calculate in Excel | Learn Excel**