How To Divide Using Excel?

Select the cell where you want the result

Type `=A1/B1` replacing `A1` and `B1` with your cell references

Press Enter

Use a number instead of a cell reference if needed, such as `=10/2`

Copy the formula to other cells by dragging the fill handle

Use absolute references with `$` if you want to keep a cell fixed, such as `=A1/$B$1`

Use `=QUOTIENT(A1,B1)` if you want only the whole-number result

Use `=MOD(A1,B1)` if you want the remainder

Suggested for You

Trending Today