How to increase a number by a percentage in excel

You can use the following basic formula to multiply a column by a percentage in Excel:

For example, you can use the following formula to multiply the value in cell A1 by 50%:

You can then click and drag this formula down column A to multiply every value in column A by 50%.

The following example shows how to use this formula in practice.

Example: Multiply Column by a Percentage in Excel

Suppose we have the following list of values in Excel:

We can use the following formula to multiply the value in cell A2 by 50%:

Next, we can hover over the bottom right-hand corner of cell B2 until a tiny “+” appears.

Then click and drag down to all of the remaining cells in column B:

All of the values in column B are equal to the corresponding values in column A multiplied by 50%.

For example:

• 10 * 50% = 5.0.
• 15 * 5 0%= 7.5.
• 18 * 50% = 9.
• 20 * 50% = 10.
• 25 * 50% = 12.5.

And so on.

To multiply by a different percentage, simply change the value used in cell B2.

For example, to multiply by 90% simply

how to multiply percentage increase in excel

how to multiply and add percentage in excel