In Microsoft Excel, calculating changes in percentages or increasing/decreasing percentages are everyday activities. These activities can be completed using the percentage multiplication operation. In this article, I’ve presented four straightforward ways on how to multiply by percentage in Excel.
How to Find Percentage?
The percentage is the division of the Amount and Total in hundreds, where the Total is the denominator, and the Amount is the numerator. The formula can be written as follows:
(Amount/Total) * 100 = Percentage, %
If you have 12 eggs and gave away 4 then the given eggs in percentage would be
(4/12)*100 = 25%
I hope now you got an idea about how the percentage works.Â
How to Multiply by Percentage in Excel: 4 Easy Ways
1. Using the Multiplication Operator to Multiply by Percentage
This method shows how you can increase or decrease values by a certain percentage.
For Increment:
- Use the following formula for the increment operation:
Amount * (1 + Percentage %)
- The formula mentioned above increases the selected Amount by the Percentage chosen.
- Follow the example below to get the whole picture:
- Here, the Amount is the Price (C5 Cell, $1,500), and the Percentage is the Price Increase (D5 Cell, 10%). The formula applied in the E5 cell is below.
=C5*(1+D5)
- The output result is $1,650, which is the desired output after increasing the Amount by 10%.
- In addition to this, there is another similar example given below. Here, we manually entered the increment percentage (10%).
For Decrement:
- Use the following formula for the increment operation:
Amount * (1 – Percentage %)
- The formula mentioned above decreases the selected Amount by the Percentage chosen.
- Follow the example below to get the whole picture:
- Here, the Amount is the Price (C5 Cell, $1,500), and the Percentage is the Discount (D5 Cell, 10%). The formula applied in the E5 cell is as follows.
=C5*(1-D5)
- The output result is $1,350, which is the desired output after decreasing the Amount by 10%.
- In a similar example below, we only manually enter the decrement percentage (10%)
Read More: How to Create a Multiplication Formula in ExcelÂ
2. Using the Addition Operator to Multiply by Percentage
For Increment:
- Use the following formula for the increment operation:
Amount + (Amount * Percentage %)
- The formula mentioned above increases the selected Amount by the Percentage chosen.
- Follow the example below to get the whole picture:
- Here, the Amount is the Price (C5 Cell, $1,500), and the Percentage is the Price Increase (D5 Cell, 10%). The formula applied in the E5 cell is below.
=C5+C5*D5
- Here, the output result is $1,650, which is the desired output after increasing the Amount by 10%.
- Below, we have given a similar example. The only difference is that we have manually entered the increment percentage (10%).
For Decrement:
- Use the following formula for the increment operation:
Amount – (Amount * Percentage%)
- The formula mentioned above decreases the selected Amount by the Percentage chosen.
- Follow the example below to get the whole picture:
- Here, the Amount is the Price (C5 Cell, $1,500), and the Percentage is the Discount (D5 Cell, 10%). The formula applied in the E5 cell is:
=C5-C5*D5
- The output result is $1,350, which is the desired output after decreasing the Amount by 10%.
- We have given another example below. It is similar to the previous one but the only difference is that we have manually input the decrement percentage (10%).
3. Calculating the Change in Percentage
This method shows the percentage difference between the 2 values. Follow these steps for applying this solution:
Steps:
- First, select the cell or cells you want to show the output. We have selected cell E5.
- Secondly, calculate the difference between the new (Cell D5) and the old (Cell C5) and divide the result by the old (Cell C5) value. To do that, use the formula below.
=(D5-C5)/C5
- After that, select cell E5 again and go to Home and select the Percent Style option under the Number section, or you can press Ctrl+Shift+% as well.
- Finally, it will convert the difference into percentages and show the desired output.
4. Percentage-Percentage Multiplication
This method shows how you can multiply percentages and what type of output you could expect.
Suppose you want to calculate 10% of 50%. You can simply multiply these two with the multiplication operator (*), and you will get the output, which is 5%. You can directly multiply them or you can do it using cell references like the following.
Download Practice Workbook
You can download the workbook that I used in this article from below and practice with it by yourself.
Conclusion
You can not think of Excel without knowing how to work with percentages. In this article, I have narrowed down different ways to multiply by percentage in Excel. I hope you find the solution you were looking for. Please leave a comment if you have any suggestions or questions. Thank you.
Related Articles
- How to Divide and Multiply in One Excel Formula
- How to Multiply from Different Sheets in Excel
- How to Multiply Two Columns and Then Sum in Excel
- How to Multiply Two Columns in Excel
- How to Multiply Multiple Cells in Excel
- How to Do Matrix Multiplication in ExcelÂ
- How to Make Multiplication Table in Excel
- How to Multiply Rows in Excel
- If Cell Contains Value Then Multiply Using Excel FormulaÂ
<< Go Back to Multiply in Excel | Calculate in Excel | Learn Excel
Get FREE Advanced Excel Exercises with Solutions!