You can use the following basic formula to multiply a column by a percentage in Google Sheets:
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 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%:
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.
- 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:
Then click and drag this formula down to all of the remaining cells in column B.
The following tutorials explain how to perform other common tasks in Google Sheets: