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

`=C5*(1+D5)`
• 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.

`=C5*(1-D5)`
• \$1,350 is the output after decreasing the Amount by 10%.
• In the example below, decrement percentage (10%) will be manually entered.

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

`=C5+C5*D5`
• \$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:

`=C5-C5*D5`
• \$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 the cells. 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.
`=(D5-C5)/C5`

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

## Related Articles

<< Go Back to Multiply in Excel

Get FREE Advanced Excel Exercises with Solutions!
Chinmoy Mondol

Chinmoy Mondol is a computer engineer who loves exploring Excel and VBA programming. Programming, to him, is a time-saving tool for efficiently managing data, files, and internet tasks. He is proficient in C, C++, Python, JavaScript, HTML, SQL, MySQL, PostgreSQL, Microsoft Office, and VBA and goes beyond the basics. He holds a B.Sc. in Computer Science and Engineering from American International University-Bangladesh. He has transitioned into the role of a content developer. Beyond his work, find him immersed... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF