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.