Multiplication is one of the basic mathematical processes that is frequently used in spreadsheets. Knowing how to multiply in Google Sheets is essential whether calculating product numbers, financial estimates, or analyzing numerical data.

In this post, we will explore the methods of multiplication in Google Sheets with the help of five examples.

**What is the Multiplication in Google Sheets?**

The mathematical operation of multiplying two or more numbers or values within a spreadsheet is referred to as multiplication in Google Sheets. It is an essential arithmetic operation that is used for many things, including figuring out how much of something to buy, predicting expenses, making financial estimates, and analyzing numbers.

The multiplication operator in Google Sheets is the asterisk (*), which is used to accomplish multiplication. It can be used to build robust multiplication calculations to manipulate data and provide precise answers by mixing numbers, cell references, and formulas.

**How to Multiply Values with Cell References in Google Sheets?**

To multiply with the cell references in Google Sheets, we will use the** asterisk(*)** sign, and to understand it, we will multiply the values of cells “**A1**” and “**B1**” in cell **C1**:

```
=A1*B1
```

Press the **ENTER** key to display the output:

**How to Multiply in Google Sheets using Functions?**

To multiply in Google Sheets, we can also use the **PRODUCT()** function with the two cell references as the parameters of this function. For example, we will multiply the values of cells **A2** and **B2** in cell **C2** using the **PRODUCT()** function:

```
=PRODUCT(A2, B2)
```

This function will multiply the values of cells **A2** with **B2** and display the result in **C2**:

**How to Multiply Ranges of Data in Google Sheets?**

To multiply the ranges of Data in Google Sheets, we will use the asterisk sign between the parameters of the “**ARRAYFORMULA()**” function. For example, we will multiply the range of “**A3 to A5**” with the range of “**B3 to B5**”:

```
=ARRAYFORMULA(A3:A5 * B3:B5)
```

It will multiply the ranges and display the result of each value in the corresponding cells:

**How Do I Multiply More Than 2 Numbers in Google Sheets?**

To multiply more than 2 numbers in Google Sheets, we can use the “**PRODUCT**” function. For example, we will multiply the values of cells** A1**,**B5**, **C4**, and **A5** using the **PRODUCT** function:

```
=PRODUCT(A1, B5, C4, A5)
```

The result of the function will be displayed in cell C6 after pressing the **ENTER** key:

**How to Multiply Columns in Google Sheets?**

To multiply the entire columns in Google Sheets, we can use the **ARRAYFORMULA()** function and define the ranges of the columns supposed to multiply. For example, we will multiply the values of column **B** with column **C** and display the results in column **D** using the **ARRAYFORMULA() **function:

```
=ARRAYFORMULA(B1:B * C1:C)
```

The result will be displayed after pressing the **ENTER** key:

**Conclusion**

To multiply the values, cells, or ranges in the Google Sheets, we can use either the **asterisk(*)** symbol or the **PRODUCT() **function. For a better understanding, five examples of different cases have also been explained in this post. Multiplication is among the most used skill in calculations using Google Sheets.