How To Multiply Cells On Google Sheets

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.

Step 1

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.

Step 2

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.

Step 3

Hit the Enter key to evaluate the formula.

Step 4

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.

Step 5

Next, we’ll start the MULTIPLY function by typing the string “=MULTIPLY(“.

Step 6

Add the first factor as the first argument of the MULTIPLY function.

Step 7

Hit the Enter key to return the product of both arguments.

Step 8

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.

Step 9

Type ‘=ARRAYFORMULA(’ to start the formula.

Step 10

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.

Step 11

Hit the Enter key to evaluate the ARRAYFORMULA function.

Step 12

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’.

Summary

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.