How To Do Division In Excel?

Use the division operator `/`

Enter a formula like `=A1/B1`

Replace `A1` and `B1` with the cells you want to divide

Divide a cell by a number with `=A1/5`

Divide a number by a cell with `=10/B1`

Divide multiple values with `=A1/B1/C1`

Use parentheses to control order, such as `=(A1+B1)/C1`

Copy the formula to other cells using the fill handle

Use `=QUOTIENT(A1,B1)` to return only the whole-number result

Use `=MOD(A1,B1)` to return the remainder

Suggested for You

Trending Today