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.
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.
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.
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.
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.
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:
- AVERAGE Function
- MAX Function
- MIN Function
- FLATTEN Function
- GROWTH Function
- Transpose Data
- SORT Function
- How To Round
- How To Multiply
- How To Divide
- How To Subtract
- 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
- Sum Columns or Rows
- SUMPRODUCT Formula
- How To Create A Function
- How To Create Formula