How to multiply numbers in Google Sheets

Need to multiply two whole numbers, multiply a few cells or several columns? You can do it on Google Sheets, not just in one way. And here is how.

Need to multiply two whole numbers, multiply a few cells or several columns? You can do it on Google Sheets, not just in one way. And here is how.

  1. 6 useful functions in Google Sheets you may not know
  2. How to link data between spreadsheets in Google Sheets
  3. How to use the AVERAGE function in Google Sheets

Multiply two integers together

There are two ways to multiply two numbers together. One is to use the integrated formula and the other is to use the multiplication operator to complete the calculation. Both ways work almost the same.

Use the MULTIPLY formula

Open a browser, access Google Sheets and open a spreadsheet.

Click in the empty box and type =MULTIPLY(,) , replace and with the integer you want to multiply.

How to multiply numbers in Google Sheets Picture 1

You can also use data inside other cells. Instead of typing the numbers, type the number of the cell and Sheets will automatically fill the whole number with that cell in the correct position.

How to multiply numbers in Google Sheets Picture 2

After setting the number or cell number, press Enter to display the result in that cell.

How to multiply numbers in Google Sheets Picture 3

Use the operand

This method uses the multiplication operator (*) to find the product of numbers. The difference from the above method is that you can enter more than two numbers multiplied, while the previous formula is limited to two numbers.

From a Google Sheets spreadsheet, click in the blank cell and type = * , replace and with the integer you want to multiply.

How to multiply numbers in Google Sheets Picture 4

As before, you can reference other cells in the spreadsheet. Replace the number with the number of cells containing the integer.

How to multiply numbers in Google Sheets Picture 5

After entering an integer or number of cells, press Enter to get the multiplication result.

How to multiply numbers in Google Sheets Picture 6

Tip : If you work with tables and want to multiply data from row 1 and row 2 into row 3, Google Sheets has a handy feature that applies formulas to the remaining cells. It will fill the remaining cells with formulas and results. Double click the small blue square and the rest of the table is filled with the result of multiplying two rows.

How to multiply numbers in Google Sheets Picture 7

The kernel uses the ArrayFormula function

The next method uses the ArrayFormula function to display values ​​returned from multiple rows or columns of the same size.

In the Google Sheets spreadsheet, click in the blank cell and type =ARRAYFORMULA( * , replace and with the two columns you want to multiply. It should look like this:

 =ARRAYFORMULA(A:A*B:B) 

How to multiply numbers in Google Sheets Picture 8

If the table has a heading in the first column, Sheets will display an error because it only takes numbers as parameters.

How to multiply numbers in Google Sheets Picture 9

Therefore you should start with the first column containing numbers. For example, instead of A: A * B: B, you need to type A2: A * B2: B.

How to multiply numbers in Google Sheets Picture 10

One thing to keep in mind is that when using this formula, empty cells with no numbers will display a result of 0. However, adding other data to the Sheets table will replace the number 0 with the actual result.

How to multiply numbers in Google Sheets Picture 11

If you want to limit the number to 0 in the result, you should select a specific range when entering the formula. The new formula will be:

 =ARRAYFORMULA(B2:B100*C2:C100) 

With this formula, the spreadsheet uses only 100 cells as a reserve for all data entered later. You can edit the formula, delete any unused cells by changing 100 to smaller numbers.

When you need to multiply whole numbers, data from two cells, or the entire contents of a cell, Google Sheets provides several ways for you to calculate numbers.

I wish you successful implementation!

3.8 ★ | 13 Vote | 👨 2587 Views
« PREV POST
NEXT POST »