Home Web AppsGoogle Sheets How to multiply numbers in Google Sheets

How to multiply numbers in Google Sheets

by Dan Millward
How to multiply numbers in Google Sheets

Multiplying numbers in Google Sheets is an easy process and is very similar to other basic calculations you can do in spreadsheets.

We’ll take a look at two different ways of multiplying numbers in Google Sheets. First, we’ll look at using a formula to multiply one number inside a cell by another number in a different cell. Then we’ll look at multiplying numbers by using a specific number not contained withinside a cell.

How to Multiply using figures contained in cells

In this example, we’ve got a number in cell A1 and we want to multiply that number against the number in cell B1. Below you can see the formula you would use to do this. The formula used has been written in cell C1, but you could choose to write the formula in any cell.

How to multiply numbers in Google Sheets

Here is the formula you would use:

  1. Select cell C1
  2. Type the following formula =A1*B1
  3. Press return

If you’ve done the formula correctly you should get the result of ’30’. As you can see from above you use the asterisk key ‘*’ to do a multiplication.

How to multiply using a figure in a cell against a number not included on the spreadsheet

The above example used data on the spreadsheet. However, there may be times when you need to multiply numbers on a spreadsheet without using data from the spreadsheet itself. Let’s take a look at how to do this.

How to multiply numbers in Google Sheets

Above you can see cell A1 contains the number ’10’. However, on this occasion, there are no other figures on the spreadsheet to multiply against. When creating a formula in Google Sheets the information does not always need to be on the spreadsheet itself. You can see from the example above we’ve multiplied cell A1 by 2.

Here is the formula you would use:

  1. Select cell C1
  2. Type the following formula =A1*2
  3. Press return

You may also be interested in

How to subtract numbers in Google Sheets

How to add numbers in Google Sheets 

How to divide numbers in Google Sheets

Related Articles