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.
Here is the formula you would use:
- Select cell C1
- Type the following formula =A1*B1
- 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.
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:
- Select cell C1
- Type the following formula =A1*2
- Press return
You may also be interested in
How to subtract numbers in Google Sheets