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:

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:

- Select the cell or cells you want to show the output to.
- Calculate the difference between the
**new (Cell C2)**and the**old (Cell B2)**and divide the result by the**old (Cell B2)**value. - 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.