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.
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,
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.
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.
- Press Enter to see the result.
- Use the Fill Handle to tool copy the formula to the rest of the Rows.
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
- Press Enter to see the increased price.
- Lastly, use the Fill Handle to get the same result for the rest of the items.
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.
- Press Enter and use the Fill handle to get the entire column.
- Again, in cell F6, type the following formula.
- 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
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.
- 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.
- After that, select the output range E6:E11 and right-click to get the context menu. Here, select Paste Special.
- 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.
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.
- 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
- 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.
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.
- How to Calculate Cumulative Percentage in Excel
- 2 Ways to Calculate Bacterial Growth Rate in Excel
- Calculate Percentage Change with Negative Numbers in Excel
- 4 Simple Ways to Calculate Forecast Accuracy Percentage in Excel
- Calculate Percentage in Excel Based on Conditional Formatting
- 4 Easy Ways to Calculate Percentage in Excel Based on Cell Color