Last Updated on November 1, 2023 by Jake Sheridan

In this tutorial, you will learn how to multiply in Google Sheets.

## How to Multiply in Google Sheets

Multiplication is an important part of mathematics, and Google Sheets offers several ways to multiply values.

You can use its built-in function MULTIPLY to multiply two or more values, or you can use the multiplication operator (*) to multiply values in a single cell.

In this guide, we will provide a step-by-step explanation of how to use formulas and the multiplication operator to multiply values in Google Sheets.

We will also show an example of multiplying two cell ranges together.

## How to Multiply Values in Google Sheets

Here’s how to multiply values in Google Sheets.

### Step 1

The simplest way to multiply two values is by using the “*” operator. Simply place the “*” operator between two numbers you want to multiply.

In the example above, we calculated that 2 * 3 is equal to 6. Do note that users can also use cell references to values instead of the values themselves. For example, “A2*3” and “B3*B5” are all valid formulas.

### Step 2

We can also use the MULTIPLY function to find the product of two values.

A limitation of the MULTIPLY function is that it only accepts two scalar values.

### Step 3

If you want to return a product of two ranges, we can create an array formula that multiplies said ranges.

First, select the cell where you want to output the result of the array formula.

### Step 4

Next, type the string “=ARRAYFORMULA()”

As an argument, type the two ranges you want to find the product of. Add a multiply operator between these two ranges.

The array formula should automatically return an entire range that is considered the product of both ranges in the argument.

## Summary

This guide should be everything you need to multiply in Google Sheets.

You may make a copy of this example spreadsheet to test it out on your own.

#### More basic math formulas in Google Sheets:

- Addition
- Subtract
- Divide
- Exponents
- AVERAGE Function
- MAX Function
- MIN Function
- FLATTEN Function
- FREQUENCY
- GROWTH Function
- Transpose Data
- SORT Function
- How To Round
- How To Multiply
- How To Divide
- How To Subtract
- Percentages
- SUMIF
- Round Down
- Add Cells
- Multiply Cells
- Subtract Cells
- Find Median
- Find Quartiles
- Automatically Add Numbers
- Find Mean
- Standard Deviation
- Find Average
- Find Range
- Find Variance
- T Test
- Use Pi In Google Sheets
- How To Square
- Square Root
- Trimmean
- Sum Columns or Rows
- Sumif
- SUMPRODUCT Formula
- How To Create A Function
- How To Create Formula