Google Sheets Multiplication Operator

Multiplication Operator

Multiplication uses the * symbol in Google Sheets.

How to multiply cells:

1. Select a cell and type (=)
2. Select a cell
3. Type (*)
4. Select another cell
5. Hit enter

You can add more cells to formula by typing (*) between the cells.

Let's have a look at some examples.

Multiplying Manual Entries

Let's start with adding in a formula. Start with a clean sheet.

Step by step:

1. Type A1(=)
2. Type 2*2
3. Hit enter

Multiplying Two Cells

Let's add some numbers to work with. Type the following values:

Step by step:

1. Type A3(=)
2. Select A1
3. Type (*)
4. Select A2
5. Hit enter