Multiplying numbers in Google Sheets

The easiest way to multiply two numbers in Google Sheets is to create a formula in a sheet cell.

Important points to remember about Google Spreadsheet formulas:

  • Formulas always start with an equal sign ( = );

  • The equal sign always comes in the cell where you want the answer;

  • The multiplication operator is an asterisk ( * );

  • The formula is completed by pressing the key Enter on keyboard.

You may hear that the terms formula and function are used interchangeably, but they are not the same. A formula is an expression used to calculate the value of a cell. But a function in Google Sheets is a predefined formula that allows you to perform more complex calculations effortlessly.

  1. try it
  2. Using cell references in formulas
  3. Advantages of mobile connections
  4. Example of multiplication formula
  5. Enter a formula
  6. Change formula data
  7. Change the formula
  8. Multiply across multiple rows

try it

The best way to see how multiplication works in Google Sheets is to try it yourself.

  1. Open Google Sheets and click on a cell to start typing.

  2. Enter an equal sign ( = ).

  3. Then enter the number.

  4. Enter an asterisk ( * ) to indicate multiplication.

  5. Enter the second number to multiply.

  6. Click Enter to see the result.

Using cell references in formulas

Although entering numbers directly into the formula works. it’s not the best way to create formulas.

The best way is to use cell references. Cell references are essentially variables that hold the data in the cells they refer to, hence the name. It allows you to quickly change data in cells and dynamically copy formulas across columns and rows to different data sets.

Cell references are a combination of a vertical column letter and a horizontal row number, with the column letter always written first, for example, A1, D65, or Z987.

Advantages of mobile connections

Cell references are used to find the data used in a formula. The program reads the cell references and then inserts the data in those cells into the appropriate place in the formula.

By using cell references instead of the actual data in the formula. If you need to change the data later, you can simply replace the data in the cells instead of rewriting the formula.

Typically, formula results are automatically updated when the data changes.

Example of multiplication formula

Working with cell references is not much different from working with regular numbers. Start with an equal sign. Enter a link in the first cell, say A2 . Enter an asterisk. Follow this with the second link. If you multiply A2 and B2 in a cell C2 , the completed formula in the cell C2 will look like:

= A2 * B2

Enter a formula

  1. Start filling in your details. Create two columns, each with multiple numbers. Assuming you’ve labeled your columns, this tutorial will get you started on multiplying data in A2 and B2 in a cell C2 .

  2. Select cell C2 to make it the active cell – displays the results of the formula here.

  3. Enter equal sign ( = ) to cell C2.

  4. Select cell A2 mouse pointer to enter that cell reference into the formula. You can also join A2 , if you want.

  5. Enter asterisk symbol ( * ) after A2.

  6. Select cell B2 use the mouse pointer to enter a reference to that cell. Again, you can always call it too.

  7. Press key Enter on the keyboard to complete the formula.

  8. The answer must be in cell C2.

  9. Even though the answer is displayed in cell C2, selecting that cell will display the actual formula =A2*B2 in the formula bar above the worksheet.

Change formula data

To check the value of using cell references in a formula:

  • Change number in cell A2 and press the key Enter on keyboard.

The answer in cell C2 should update automatically to reflect the change in the data in cell A2.

Change the formula

If the need arises to correct or change the formula, two of the best options are:

  • Double-click a formula in a sheet to place Google Sheets Change and then make changes to the formula – best suited for minor changes.

  • Click once on the cell with the formula and rewrite the whole formula – best for big changes.

Multiply across multiple rows

Since you are working with cell references, you can copy the formula to multiple cells to apply it to multiple rows at the same time.

  1. In the previous example, select a cell C2 , which has your formula.

  2. To hold ctrl / order and press C to copy the data to the cell.

  3. Click and drag to highlight other cells in the same column C , which is the formula.

  4. To hold ctrl / order and press V to paste the formula into the selected cells.

  5. The selected cells are immediately filled with the results of the multiplication from the formula.

  6. Select one of the result cells and you will see that the formula in the cell correctly references the corresponding cells in columns A and B. This is because Google Sheets automatically updates to refer to the correct row when you paste the formula.

Leave a Reply

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