How to Multiply by Percentage in Excel (4 Easy Ways)

Get FREE Advanced Excel Exercises with Solutions!

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%)

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.

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

<< Go Back to Multiply in Excel

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

Chinmoy Mondol is a computer engineer who loves exploring Excel and VBA programming. Programming, to him, is a time-saving tool for efficiently managing data, files, and internet tasks. He is proficient in C, C++, Python, JavaScript, HTML, SQL, MySQL, PostgreSQL, Microsoft Office, and VBA and goes beyond the basics. He holds a B.Sc. in Computer Science and Engineering from American International University-Bangladesh. He has transitioned into the role of a content developer. Beyond his work, find him immersed... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF