how to multiply

Google Sheets icon

Whether you have two integers, a few cells, or a couple of columns that need to be multiplied together, Google Sheets provides a few different ways to find the product of your data. Here’s how.

tmntag.cmd.push(function(){tmntag.adTag(‘purch_N_C_0_1’, false);});

Multiply Two Integers Together

There are two ways to find the product of two numbers. One uses a built-in formula, while the other uses the multiply operand to complete the calculation. Both work virtually the same and multiply numbers just as you would expect.

Using the MULTIPLY Formula

Fire up your browser, head to Google Sheets, and open a spreadsheet.

Click on an empty cell and type =MULTIPLY(<number1>,<number2>) into the formula entry field, replacing <number1> and <number2> with the two integers you want to multiply.

Click on an empty cell and type "=Multiply(2,3)" and hit the Enter key to find the product of 2 and 3.

You can also use the data inside another cell. Instead of a number, type the cell number and Sheets will automatically put the integer from that cell in its place.

Instead of a number, type the cell number, and Sheets automatically puts the data from that cell in its place.

After you input the numbers or cell numbers, press the Enter key and Sheets will place the results in the cell.

Tada! The results are in!

Using the Multiply Operand

This method uses the multiply operand (*) to find the product of some numbers. The only difference is you’re able to input more than two multiplicands, whereas the previous formula is limited to two.

From your Google Sheets spreadsheet, click an empty cell and type =<number1> * <number2> into the formula entry field, replacing <number1> and <number2> with the two integers you want to multiply.

Click on an empty cell and type in "=8*2" to find the product of 8 and 2.

Just like before, you can reference other cells inside the spreadsheet. Replace either number with the number of a cell that contains an integer in it.

Just as you did before, replace one of the integers with the cell number that you want to use.

After you input the integers or cell numbers, press the Enter key and Sheets will place the results in the cell.

Tada! The results are generated for you to view.

Pro tip: If you’re working with a table and want to multiply the data from rows 1 and 2 into row 3, Google Sheets has a neat feature that applies the formula to the remaining cells. It fills in the remaining cells with the formula and the results. Double-click the little blue square, and, like magic, the rest of the table is filled in with the product of the two numbers.

Click on the little blue square of the cell you entered the formula in to apply it to the rest of the table.

Multiply Using ArrayFormula

This next method uses the  ARRAYFORMULA function to display values returned from multiple rows or columns of the same size.

From your Google Sheets spreadsheet, click an empty cell and type =ARRAYFORMULA(<column1> * <column2>) into the formula entry field, replacing <column1> and <column2> with the two columns you want to multiply. It should look something like this:

=ARRAYFORMULA(A:A*B:B)

click an empty cell and type "=ARRAYFORMULA(<column1> * <column2>)" into the formula entry field.

If your columns have a header in the first row, Sheets will throw an error because it expects only numbers as parameters.

If you have headers at the top of a table, you will see this error. This just means that the formula only accepts integers as values, not words.

Instead, you will need to start with the first cell that contains a number. For example,  instead of A:A*B:B , you would type A2:A*B2:B into the formula.

Start your range from the next row down instead. In this case, we will start at B2 and C2.

The only caveat to using the formula like this is any empty cells will use “0” in the formula. However, any other data you add to the table gets calculated dynamically, replacing each zero with the results.

Unless specified, you will have a long list of zeros at the end of your results.

If you want to limit the number of trailing zeros in your results, you should select a fixed range when you enter the formula. The new formula will look like this:

=ARRAYFORMULA(B2:B100*C2:C100)

This way, the spreadsheet uses only 100 cells as a reserve for any data you enter later. You can edit the formula and remove any unused cells by changing the 100 to a smaller number.


Whether you need to multiply static integers, data from two cells, or the entire contents of two columns, Google Sheets provides a couple of methods to help you calculate the product.

body #primary .entry-content ul#nextuplist {list-style-type: none;margin-left:0px;padding-left:0px;}
body #primary .entry-content ul#nextuplist li a {text-decoration:none;color:#1d55a9;}

Leave a Reply

Your email address will not be published. Required fields are marked *