How to Divide Numbers in Google Sheets

Here are the various ways you can divide numbers on Google Sheets. You can divide individual cells and entire columns.

4 methods of dividing numbers in Google Sheets 

  • Dividing numbers in cells using DIVIDE function
  • Dividing numbers in cells using divide operator
  • Dividing entire columns 
  • Dividing without a remainder 

Method 1: Dividing numbers in cells using DIVIDE function

The DIVIDE function is an inbuilt function to aid division within Google Sheets with a simple syntax. 

Step 1: Identify the cells on which you will be applying the division. 

In this case, we are taking cell E4 as the dividend and cell F4 as the divisor.

Step 2: Apply the correct syntax.

Syntax for DIVIDE function is as follows: 

= DIVIDE(dividend, divisor) 

Here’s the result that will be displayed. 

You can also input the cell values itself to get the result. 


Method 2: Dividing numbers in cells using divide operator

All of us are familiar with the division operator on a standard keyboard- / . Google Sheets also gives us that option. 

Step 1: Identify the cells on which you will be applying the division. 

We are taking cell E4 as the number which will be divided and cell F4 as the divisor here.

Step 2: Use the division operator. 

You can simply use the division operator between the cells like this. 

= (dividend/divisor)

You can also input the cell values itself to get the result.


Method 3: Dividing entire columns

You can use ARRAYFORMULA to divide entire columns. 

Step 1: Identify the columns on which you will be applying the division. 

In this case we are taking column E4 as the dividend and column F4 as the divisor. 

Step 2: Apply the correct syntax. 

Syntax for ARRAYFORMULA is as follows: 

= ARRAYFORMULA( data array that you need to divide, divisor array or the data array by which you are dividing the cell) 

You can see the result in Column H is without any decimal points. 


Method 4: Divide without a remainder 

You can use the INT function with the ARRAYFORMULA when you need the result without any decimal points. 

Step 1: Identify the columns on which you will be applying the division. 

In this case we are taking column E4 as the dividend and column F4 as the divisor.  

Step 2: Apply the correct syntax. 

Syntax for ARRAYFORMULA with the INT function is as follows: 

= ARRAYFORMULA(INT( dividend array, divisor array))

You can see the result in Column H is without any decimal points. 


Conclusion 

We hope that you found these methods useful. Let us know if you would like us to add more to the methods covered here.

Leave a Comment