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

In MS Excel, calculating changes in percentages or increasing/decreasing percentages are everyday activities. These activities can be completed using the percentage multiplication operation. I’ve presented four straightforward ways to accomplish this percentage multiplication operation in this article.

Download the Workbook

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

4 Ways to Multiply by Percentage in MS Excel

How percentage works

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 in percentage would be

(4/12)*100 = 25%

I hope now you got an idea about how percentage works. 

1. Using the Multiplication Operator

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:

Increasing the Price by 10% (Cell Ref)

Here, the Amount is the Price (B2 Cell, $1,500), and the Percentage is the Price Increase (D2 Cell, 10%). The formula applied in the F2 cell [B2*(1+D2)], and the output result is $1,650, which is the desired output after increasing the Amount by 10%.

This is similar example. Only the increment percentage (10%) is manually entered.

Increasing the Price by 10% (Manual Input)

Breakdown:

Amount * (1 + Percentage %)

=> B2*(1+D2)

=> $1,500 * (1+10%)

=> $1,500 * 110%

=> $1,650

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:

Decreasing the Price by 10% (Cell Ref)

Here, the Amount is the Price (B2 Cell, $1,500), and the Percentage is the Discount (C2 Cell, 10%). The formula applied in the E2 cell [B2*(1-D2)], and the output result is $1,350, which is the desired output after decreasing the Amount by 10%.

This is a similar example. Only the decrement percentage (10%) is manually entered.

Decreasing the Price by 10% (Manual Input)

Breakdown:

# Amount * (1 – Percentage %)

=> B2*(1-D2)

=> $1,500 * (1-10%)

=> $1,500 * 90%

=> $1,350

2. Using the Addition operator

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:

Increasing the Price by 10% (Cell Ref)

Here, the Amount is the Price (B2 Cell, $1,500), and the Percentage is the Price Increase (D2 Cell, 10%). The formula applied in the F2 cell [B2+(B2*D2)], and the output result is $1,650, which is the desired output after increasing the Amount by 10%.

This is a similar example. Only the increment percentage (10%) is manually entered.

Increasing the Price by 10% (Manual Input)

Breakdown:

# Amount + (Amount + Percentage %)

=> B2+(B2*D2)

=> $1,500 + ($1,500*10%)

=> $1,500 + $150

=> $1,650

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:

Decreasing the Price by 10% (Cell Ref)

Here, the Amount is the Price (B2 Cell, $1,500), and the Percentage is the Discount (C2 Cell, 10%). The formula applied in the E2 cell [B2-(B2*C2)], and the output result is $1,350, which is the desired output after decreasing the Amount by 10%.

This is a similar example. Only the decrement percentage (10%) is manually entered.

Decreasing the Price by 10% (Manual Input)

Breakdown:

Amount – (Amount + Percentage%)

=> B2-(B2*C2)

=> $1,500 – ($1,500*10%)

=> $1,500 – $150

=> $1,350

3. Calculating the change in percentage

This method shows the percentage difference between 2 values.

Follow these steps for applying this solution:

  1. Select the cell or cells you want to show the output to.
  2. Calculate the difference between the new (Cell C2) and the old (Cell B2) and divide the result by the old (Cell B2) value.Calculating the change
  3. Now, select the cell again and go to Home and select the Percent Style option under the Number section, or you can press Ctrl+Shift+% as well.Selecting the Percent Style option

It will convert the difference into percentages and show the desired output.

Change in percentage

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 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 using cell reference

Conclusion

You can not think of Excel without knowing how to work with percentages. In this article, I have narrowed down different ways for multiplying percentages in MS Excel. I hope you find the solution you were looking for. Please leave a comment if you have any suggestions or questions. Thank you.

Further Readings

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