Table of Contents
To multiply a column in Google Sheets by a percentage, follow these steps:
1. Select the column that you want to multiply.
2. Click on the first cell in the column.
3. Type in the percentage that you want to multiply the column by, followed by the percent symbol (%).
4. Press Enter on your keyboard.
5. The column will now be multiplied by the specified percentage.
6. To apply this to the rest of the cells in the column, click and drag the bottom right corner of the first cell to the bottom of the column.
7. Release the mouse button to apply the formula to the rest of the cells.
8. The column will now be multiplied by the percentage, displaying the results in each cell.
This method can be useful for calculating discounts, tax amounts, or any other situations where a percentage needs to be applied to a column of data.
Google Sheets: Multiply Column by a Percentage
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.
Additional Resources
The following tutorials explain how to perform other common tasks in Google Sheets:
Cite this article
stats writer (2024). How can I multiply a column in Google Sheets by a percentage?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-multiply-a-column-in-google-sheets-by-a-percentage/
stats writer. "How can I multiply a column in Google Sheets by a percentage?." PSYCHOLOGICAL SCALES, 1 Jul. 2024, https://scales.arabpsychology.com/stats/how-can-i-multiply-a-column-in-google-sheets-by-a-percentage/.
stats writer. "How can I multiply a column in Google Sheets by a percentage?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-multiply-a-column-in-google-sheets-by-a-percentage/.
stats writer (2024) 'How can I multiply a column in Google Sheets by a percentage?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-multiply-a-column-in-google-sheets-by-a-percentage/.
[1] stats writer, "How can I multiply a column in Google Sheets by a percentage?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, July, 2024.
stats writer. How can I multiply a column in Google Sheets by a percentage?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.