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%.
- 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 use the following formula:
Then click and drag this formula down to all of the remaining cells in column B.
Each value in column B will now be equal to the corresponding values in column A multiplied by 90%.
- 10 * 90% = 9.
- 15 * 90% = 13.5.
- 18 * 90% = 16.2.
- 20 * 90% = 18.
- 25 * 90% = 22.5.
And so on.
The following tutorials explain how to perform other common tasks in Excel:
How to Multiply Column by a Constant in Excel
How to Find the Top 10% of Values in an Excel Column
How to Find Unique Values from Multiple Columns in Excel
How to Sort by Multiple Columns in Excel