# 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.