Table of Contents
To multiply a column by a percentage in Google Sheets, use the formula =C2*D2, where C2 is the cell containing the value to be multiplied and D2 is the cell containing the percentage to multiply it by. The formula can then be extended to the rest of the column by dragging the formula down the column. This will apply the percentage multiplication to the entire column.
You can use the following basic formula to multiply a column by a percentage in Google Sheets:
=CELL*(PERCENT/100)
For example, you can use the following formula to multiply the value in cell A1 by 50%:
=A1*(50/100)
You can then click and drag this formula down 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 Google Sheets
Suppose we have the following list of values in Google Sheets:
We can use the following formula to multiply the value in cell A2 by 50%:
=A2*(50/100)
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 50% of the values in column A.
For example:
- 50% of 10 is 5.
- 50% of 15 is 7.5
- 50% of 18 is 9.
- 50% of 20 is 10.
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:
=A2*(90/100)
Then click and drag this formula down to all of the remaining cells in column B.