How to Add 15 Percent to a Price in Excel (2 Easy Methods)

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.


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.

 how to add 15 percent to a price in excel


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.

Adding 15% to a price formula 1

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

Adding 15% to a price formula 2

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

Adding 15% to a price formula 3

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

The SUM Function adds the values of cells C7 and D7.
  • 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.

Adding 15 percent to a price formula 4

Here, $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.

Use of paste special

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

use of paste special method

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.


Mehedi Hasan Shimul

Mehedi Hasan Shimul

Hi! I am Mehedi Hasan Shimul. As I am an Engineer solving different problems with the help of Excel amuses me. I write Excel related different problem solving articles here. Hope it will help you.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo