How to Multiply by Percentage in Excel – 4 Easy Methods

Method 1 – Using the Multiplication Operator to Multiply by Percentage

For Increment:

• Use the following formula:

Amount * (1 + Percentage %)

It increases the selected Amount by the chosen Percentage.

Check the example below.

Here, the Amount is the Price (C5, $1,500), and the Percentage is the Price Increase (D5, 10%). The formula applied in E5 is the following:

The output is $1,650 (The Amount was increased by 10%).

In the example given below the increment percentage (10%) was manually entered.

For Decrement:

• Use the following formula:

Amount * (1 – Percentage %)

The formula decreases the selected Amount by the chosen Percentage .

Check the example below.

Here, the Amount is the Price (C5, $1,500), and the Percentage is the Discount (D5, 10%). The formula applied in E5 is the following.

$1,350 is the output after decreasing the Amount by 10%.

In the example below, decrement percentage (10%) will be manually entered.

Read More: How to Create a Multiplication Formula in Excel 

Method 2 – Using the Addition Operator to Multiply by Percentage

For Increment:

• Use the following formula:

Amount + (Amount * Percentage %)

The formula increases the selected Amount by the chosen Percentage .

Check the example below:

Here, the Amount is the Price (C5, $1,500), and the Percentage is the Price Increase (D5, 10%). The formula applied in E5 is the following.

$1,650, is the output after increasing the Amount by 10%.

Below is a similar example. The only difference is that the increment percentage (10%) was  manually entered.

For Decrement:

• Use the following formula.

Amount – (Amount * Percentage%)

The formula decreases the selected Amount by the chosen Percentage.

Check the example below.

Here, the Amount is the Price (C5, $1,500), and the Percentage is the Discount (D5, 10%). The formula entered in E5 is:

$1,350 is the output after decreasing the Amount by 10%.

In the example below the decrement percentage (10%) was manually entered.

Method 3 – Calculating the Change in the Percentage

Steps:

• Select a cell. Here, E5.
• Calculate the difference between the new cell (D5) and the old cell (C5) and divide the result by C5. Use the formula below.

• Select E5, go to the Home tab and select Percent Style in Number. You can also press Ctrl+Shift+%.

This is the output.

Method 4 – Percentage-Percentage Multiplication

To calculate 10% of 50%,  simply multiply these two with the multiplication operator (*). 5% is the output.

You can also use cell references as shown below.

Download Practice Workbook

Download the workbook and practice.

Related Articles

• How to Divide and Multiply in One Excel Formula
  
• How to Multiply from Different Sheets in Excel
  
• How to Multiply Two Columns and Then Sum in Excel
• How to Multiply Two Columns in Excel
• How to Multiply Multiple Cells in Excel
• How to Do Matrix Multiplication in Excel 
• How to Make Multiplication Table in Excel
• How to Multiply Rows in Excel
• If Cell Contains Value Then Multiply Using Excel Formula 

<< Go Back to Multiply in Excel | Calculate in Excel | Learn Excel