Google Sheets Header

Whether you need to divide static integers or data from two cells or the entire contents of two columns, Google Sheets provides a couple of methods to help you calculate the quotient. Here’s how.

Using the DIVIDE Formula

Fire up your browser, head to Google Sheets, and open a spreadsheet.

Click on an empty cell and type =DIVIDE(<dividend>,<divisor>) into the cell or the formula entry field, replacing <dividend> and <divisor>with the two numbers you want to divide.

Note: The dividend is the number to be divided, and the divisor is the number to divide by.

Type "=DIVIDE(<dividend>,<divisor>)" into the cell, replacing <dividend> and <divisor> with the two numbers you want to divide. 

You can also use the data inside another cell. Instead of a number, type the cell number and Sheets will automatically put the integer from that cell in its place.

You can also reference other cell's data by typing in the cell number you want to use.

After you input the numbers or cell numbers, press the “Enter” key and Sheets will place the results in the cell.

Press the Enter key and the results are displayed.

Using the Divide Operand

This method uses the Divide operand (/) to find the product of some numbers. The only difference is if you have more than two numbers, you’re able to input as many as you want, whereas the previous formula is limited to two.

From your Google Sheets spreadsheet, click an empty cell and type =<dividend>/<divisor> into the cell or the formula entry field, replacing <dividend> and <divisor> with the two numbers you want to divide.

Click on an empty cell and type in "=<dividend> / <divisor>" replacing <dividend> and <Divisor> with the numbers you want.

Just like before, you can reference other cells inside the spreadsheet. Replace either number with the number of a cell that contains a number in it.

Just like before, you can replace a number with the number of any cell, referencing the data in it.

After you input the numbers or cell numbers, press the “Enter” key and Sheets will place the results in the cell.

Press the Enter key to see the results.

If you’re working with a table and want to divide the data from Rows 1 and 2 into Row 3, Google Sheets has a neat feature that applies the formula to the rest of the cells in Row 3. It fills in the remaining cells with the formula and the results.

Double-click the little blue square, and, like magic, the rest of the table is filled in with the product of the two numbers. This feature can be used with either formula, but it works only when using cell references.

If you want to apply the same formula to the rest of a table, double-click the little blue square and the rest of the column underneath will

Brady Gavin Brady Gavin
Brady Gavin has been immersed in technology for 15 years and has written over 150 detailed tutorials and explainers. He's covered everything from Windows 10 registry hacks to Chrome browser tips. Brady has a diploma in Computer Science from Camosun College in Victoria, BC.  
Read Full Bio »