How To Divide In Excel?

Select the cell where you want the result.

Type `=`.

Enter the dividend (the number you want to divide).

Type `/`.

Enter the divisor (the number you want to divide by).

Press `Enter`.

To divide two cells: `=A1/B1`

To divide a cell by a constant: `=A1/10`

To divide a range by a constant (fill down/right): enter `=A1/10`, then drag the fill handle

To divide a range by a single cell: `=A1/$B$1` (use `$` to lock the divisor cell)

To divide multiple columns by the same divisor: `=A1/$B$1`, then fill across/down

To divide using percentages: `=A1/0.25` (or convert a percent like `=A1/(B1/100)`)

To avoid division by zero: `=IF(B1=0,””,A1/B1)`

To divide using whole-number division (quotient): `=QUOTIENT(A1,B1)`

To get remainder: `=MOD(A1,B1)`

Suggested for You

Trending Today