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

## How to Multiply in Google Sheets

Quick Navigation

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.