Last Updated on November 1, 2023 by Jake Sheridan
In this tutorial, you will learn how to multiply cells on Google Sheets.
How To Multiply Cells On Google Sheets
In Google Sheets, there are a few ways to multiply cells. You can use the multiplication operator (*), the multiply function, or the PRODUCT function.
The multiplication operator is the easiest way to multiply cells in Google Sheets. Simply type the asterisk (*) between the two cells that you want to multiply.
The MULTIPLU function is a built-in function in Google Sheets that allows you to multiply two or more numbers. The PRODUCT function is a built-in function in Google Sheets that allows you to multiply two or more numbers.
This guide will explain how to use all three of these methods to multiply cells in Google Sheets. We will also cover an example of using ARRAYFORMULA to multiply two ranges.
How To Calculate the Product in Google Sheets
Here’s how to calculate the product in Google Sheets.
First, we’ll cover how to multiply cells using the multiplication operator.
Select an empty cell where you want to return the product of two cells.
In this example, we plan on returning the product of Value A and B above in cell C2.
Next, type the ‘=’ equal sign to start the formula. Afterwards, type the cell references of the two products to multiply with the ‘*’ symbol in between.
Hit the Enter key to evaluate the formula.
Next, we’ll use the MULTIPLY function to find the product of two cells in Google Sheets.
Select an empty cell where you want to return the output of the MULTIPLY function.
Next, we’ll start the MULTIPLY function by typing the string “=MULTIPLY(“.
Add the first factor as the first argument of the MULTIPLY function.
Hit the Enter key to return the product of both arguments.
We’ll now explain how to use the ARRAYFORMULA to multiply two ranges together.
First, select an empty cell to place the ARRAYFORMULA. Ensure that there is enough space below this cell to accommodate the output.
Type ‘=ARRAYFORMULA(’ to start the formula.
Inside the ARRAYFORMULA function, we’ll multiply our ranges using the multiply operator.
In this example, we want to multiply the range A8:A15 with the values in B8:B15.
Hit the Enter key to evaluate the ARRAYFORMULA function.
If you want to multiply three or more numbers, we recommend using the PRODUCT function.
In the example above, we used the formula =PRODUCT(A18:A22) to multiply all the numbers in the given range with each other. The calculation is equivalent to ‘2x3x4x5x6’.
This guide should be everything you need to calculate the product 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
- 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