# How to Multiply Column by a Constant in Google Sheets

To multiply a column by a constant in Google Sheets, you'll need to use an ARRAYFORMULA function combined with the multiplication operator. Here's a step-by-step guide on how to do it:

- Open your Google Sheet containing the data you want to multiply.
- Click on an empty cell where you'd like to display the result.
- Enter the following formula in the cell:

`=ARRAYFORMULA(A1:A* constant)`

Replace `A1:A`

with the range of the column you want to multiply, and replace `constant`

with the constant value you want to multiply the column by.

- Press Enter to apply the formula.

## Example

Let's say you have a list of numbers in column A (from A1 to A5) that you want to multiply by the constant value 10. Here's how you can do it:

- Click on an empty cell where you'd like to display the result, for example, B1.
- Enter the following formula in the cell:

`=ARRAYFORMULA(A1:A5 * 10)`

- Press Enter to apply the formula.

The result will be displayed in column B, with each value in column A multiplied by 10.

Did you find this useful?