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