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

Get FREE Advanced Excel Exercises with Solutions!

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.


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.

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

Adding 15% to a price formula 3

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

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 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.
textalign=”center”] =$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 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.

use of paste special method


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.


What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Mehedi Hasan Shimul
Mehedi Hasan Shimul

Md. Mehedi Hasan, with a BSc in Electrical & Electronic Engineering from Bangladesh University of Engineering and Technology, holds a crucial position as an Excel & VBA Content Developer at ExcelDemy. Driven by a deep passion for research and innovation, he actively immerses himself in Excel. In his role, Mehedi not only skillfully addresses complex challenges but also exhibits enthusiasm and expertise in gracefully navigating tough situations, emphasizing his steadfast commitment to consistently deliver exceptional and quality content.... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo