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

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.


Download Practice Workbook

You can download the workbook that I used in this article from below and practice with it by yourself.


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. 


4 Easy Ways to Multiply by Percentage in Excel

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:

Using the Multiplication Operator to Multiply by Percentage

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

Using the Multiplication Operator to Multiply by Percentage

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

Using the Multiplication Operator to Multiply by Percentage

Read More: What is the Formula for Multiplication in Excel for Multiple Cells? (3 Ways)


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:

Using the Addition Operator to Multiply by Percentage

  • 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:

Using the Addition Operator to Multiply by Percentage

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

Read More: How to Multiply Multiple Cells in Excel (4 Methods)


Similar Readings


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

Calculating the Change in Percentage

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

Calculating the Change in Percentage

Read More: How to Divide and Multiply in One Excel Formula (4 Ways)


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.

Percentage-Percentage Multiplication

Read More: Multiplication Formula in Excel (6 Quick Approaches)


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

Chinmoy Mondol

Chinmoy Mondol

Greetings! Thank you for visiting my profile. I am Chinmoy Mondol. I am a conscientious, tech enthusiast individual with a voracious appetite for knowledge and a desire to learn more. I graduated from American International University-Bangladesh with a Bachelor's Degree in Computer Science and Engineering. I enjoy using my skills to contribute to the exciting technological advances that happen every day. Constant advancement and personal development are my guiding principles.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo