Tutorials Videos Menu
Website Pro NEW

Google Sheets Division Operator


Division Operator

Division uses the / symbol in Google Sheets.

How to do division 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 the formula by typing (/) between the cells.

Let's have a look at some examples.


Dividing Manual Entries

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

Step by step:

  1. Type A1(=)
  2. Type 4/2
  3. Hit enter


Dividing 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