3 Ways to Add Percentage to Price in Excel with Formula

You can use Excel to increase the price of your product by 10%, or any percentage for that matter. Using Excel will save you time, and you will look good while increasing your prices. In this article, we will show you how to add a percentage increase to the price with an Excel formula.


📁  Download Excel File

Download the following workbook to practice by yourself.


Learn to Add Percentage to Price in Excel with Formula Using These 3 Methods

So what does adding a percentage increase to your price actually mean? Suppose you have a product that is priced at 100 USD.  You now want to sell the product at a 15% higher price than usual for a variety of reasons. So what would be the new price? That is what we are going to find out in this article. Today we will use an Excel formula in three ways to add a percentage increase to the price. You will also use Excel’s Paste Special feature to do the same job. Finally, we will attempt to achieve the result using a VBA code. We will use a list of some items whose prices have to be increased by some percentages. I hope these methods make working with Excel easier for you.

dataset to add percentage to price

Method 1

1. Using Mathematical Formula

In this article, we will use the following formula to add a percentage increase to the price.  If we need to add an X% increase to our Old Price, the New Price will be,

Formula for Percentage Increase

In the previous section, we asked you a question about the new price of a product that is priced at 100 USD and increased by 15%. So using this formula, we can find that. If we place 15 in exchange for X in the formula, our New price would be 115 USD. Let’s use this formula in Excel.

Mathematical Formula

1.1 Technique 1

We will use the above formula in Excel directly.

⬇️⬇️ STEPS ⬇️⬇️

  • First, select your output cell as we selected E6.
  • Then, type the following formula in the Formula Bar.

=C6*(1+D6)

Formula 1 to add percentage to price

  • Press Enter to see the result.

  • Use the Fill Handle to tool copy the formula to the rest of the Rows.

Mathematical Formula

1.2 Technique 2

We can also use the above formula in the following fashion:

⬇️⬇️ STEPS ⬇️⬇️

  • First select cell E6.
  • Next, write the following formula

=C6+(C6*D6)

Formula to add percentage to price

  • Press Enter to see the increased price.

  • Lastly, use the Fill Handle to get the same result for the rest of the items.

Mathematical Formula

1.3 Technique 3

Another way to use the formula is to include a new column in which we will compute the price increase relative to the starting price. Then we will multiply the result by the old price to get the New price.

⬇️⬇️ STEPS ⬇️⬇️

  • First, we will create a new column named ‘Total Increased’ and in column E6 we will type the following formula.

=1+D6

Formula 3 to add percentage to price

  • Press Enter and use the Fill handle to get the entire column.

  • Again, in cell F6, type the following formula.

=C6*E6

Multiplication to add percentage to price

  • Subsequently, press Enter and use the Fill Handle to get the New prices of the entire column.

📕 Read More: Calculate Discount Percentage Using Formula in Excel

Method 2

2. Applying Paste Special

We can also use Excel’s Paste Special feature to add a percentage increase to our price.

⬇️⬇️ STEPS ⬇️⬇️

  • Start by entering the following formula in cell E6.

=1+D6

Adding percentage to add percentage to price

  • Then, press Enter and use Fill Handle after that.

  • Then, using the keyboard shortcut Ctrl + C, copy all of the Old Prices ranging from C6:C11.

Copying the datarange to add percentage to price

  • After that, select the output range E6:E11 and right-click to get the context menu. Here, select Paste Special.

Paste Special feature to add percentage to price

  • A dialog window for Paste Special will open. In the Operation section, choose Multiply, then click OK.

As a result, the chosen column will now contain all of the updated prices.

📕 Read More: 5 Easy Methods to Add 10 Percent to a Number in Excel

Method 3

3.  Using VBA Code

We can achieve the same goal using a VBA code if you want. To write your code, you need to first access the Developer tab. Click here to see how to access the Developer tab. Let’s see how we can use the coolest version of Excel to add the percentage increase to our price.

⬇️⬇️ STEPS ⬇️⬇️

  • First, on the left side of the Ribbon, on the Developer Tab, click Visual Basic.

Accessing visual basic to add percentage to price

  • A window (Microsoft Visual Basic for Applications) will open, and we will enter our code here. Select Module from the Insert.

  • Copy the following formula in the white module.
Sub add_percentage_to_price()
Dim Percentage As Long
With ThisWorkbook.Worksheets("Method 3")
Percentage = .Cells(Rows.Count, "C").End(xlUp).Row
.Range("E6:E" & Percentage) = "=C6*(1+D6)"
End With
End Sub

Vba code to add percentage to price

  • Finally, press F5 to see the entire column showing your increased price.

In the Rows. Count, we gave column C because that’s where Old Prices are and in the Range property, we are telling Excel three things. First, which Row to start from, second, which Column to print our results; and finally, to calculate as long as it gets the Old prices. After that, we wrote our formula to calculate the New Prices.

📕 Read More: 3 Quick Ways to Add 20 Percent to a Price in Excel


📄 Important Notes

🖊️  In the Increase Percentage column, you need to edit the Number format of the column to show the percentages.

🖊️ Ensure that some of the aforementioned formulas include parentheses.  Excel conducts multiplication operations prior to addition or subtraction.  Some of the formulas mentioned above would thus provide incorrect results. Pass the second portion of the formula in parentheses to obtain the precise result.


📝 Takeaways from This Article

📌  We explained the formula for the percentage increase in this article.

📌  How the users will use the formula in Excel was explained briefly.

📌  We also explained how the Paste Special feature could be useful here.

📌  Finally, a VBA code has been provided to conduct the operation.


Conclusion

We have come to the conclusion of our article.  I hope that after reading this article, you can easily add a percentage increase to your price in Excel.  If you have any questions, feel free to comment below.  I will try to answer them as soon as possible. Have fun using Excel, and you can visit Excelden.com for more tutorials. Thank You.


Related Articles

(Visited 35 times, 1 visits today)
Hassan Shuvo

Hassan Shuvo

Hello, I am Mehedi Hassan Shuvo.I am an Engineering graduate from Bangladesh University of Engineering and Technology. I love reading Thriller books, watching Anime, and playing Cricket. I also love learning about new software. Excel is one of my favorite ones by far. My efforts will be worthwhile if I can utilize my expertise to assist anyone. If you find any faults in my writing please let me know.I will try to correct them as I am learning everyday.

We will be happy to hear your thoughts

Leave a reply

ExcelDen
Logo