How To Divide In Google Sheets

Google Sheets is a powerful tool that allows you to perform a host of data manipulation actions with ease. One simple yet essential function you might need is division. In this post, we’ll look at how you can easily divide numbers using Google Sheets.

The Division Formula

In Google Sheets, just as with any other spreadsheet software like Microsoft Excel, the division operation can be performed using the division (“/”) operator. The basic syntax is as follows:

=number1 / number2

Step-By-Step Guide

Here are the steps to perform division in Google Sheets:

  1. Open your Google Sheets document.
  2. Click on a cell where you want to display the result of the division.
  3. Type the equals sign, which is the indication of performing a calculation.
  4. After the equals sign, input your formula. For example, if you want to divide 10 by 2, your formula should look like this: =10 / 2
  5. Press Enter. You should see the result, 5, in the cell you selected.

Dividing Cell Values

You can also divide the values of two cells. For example, if you want to divide the value of cell A1 by the value of cell B1, the formula would be =A1 / B1.

Handling Dividing by Zero Errors

Dividing by zero in mathematics is undefined, and in Google Sheets, it will return an error. To avoid this, you can use the IFERROR function to return an alternative value or message when an error is encountered. The formula would look like this:

=IFERROR(A1 / B1, "Error: Division by Zero")

This formula tells Google Sheets to perform the division, and if an error occurs (like dividing by zero), return “Error: Division by Zero”.


As you can see, dividing numbers in Google Sheets is straightforward and simple. Whether you’re dividing direct numbers or cell values, this powerful tool allows you to perform these calculations with ease. So, don’t be intimidated by spreadsheets, with practice, you will be able to harness their full power and potential.