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.