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.

**Table of Contents**hide

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

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

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

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

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

**Similar Readings**

**How to Do Matrix Multiplication in Excel (5 Examples)****Make Multiplication Table in Excel (4 Methods)****How to Multiply One Cell by Multiple Cells in Excel (4 Ways)****Multiply Rows in Excel (4 Easiest Ways)****How to Multiply Columns in Excel (9 Useful and Easy Ways)**

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

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

**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

**How to Multiply a Column in Excel by a Constant (4 Easy Ways)****If Cell Contains Value Then Multiply Using Excel Formula (3 Examples)****How to Multiply Two Columns and Then Sum in Excel (3 Examples)****Multiply from Different Sheets in Excel (5 Methods)****How to Round a Multiplication Formula in Excel (5 Easy Methods)**