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

## 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: 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. 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: 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. 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: 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. 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: 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. 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. 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. 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 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 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.  