Thursday, 31 October 2019

How to Multiply Numbers in Google Sheets

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.

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.

Read the remaining 24 paragraphs



from How-To Geek https://ift.tt/2PtgdPH

No comments:

Post a Comment