deepcalc
DocsErrors

#DIV/0!

View as markdown/docs/errors/div-0.md Ask Claude about this pageOpens Claude with this page's address

A formula divides by zero or by an empty cell.

What it means

division by zero is undefined, so the formula cannot produce a number. An empty cell counts as zero, which is why this error often appears before any data is entered.

How to fix it

  • Guard the division: =IF(B1=0, "", A1/B1).
  • Use IFERROR to show a fallback: =IFERROR(A1/B1, "").
  • Check that the denominator range actually contains numbers.

Common causes

  • An explicit division by zero, e.g. =1/0.
  • The divisor cell is empty or holds 0.
  • AVERAGE over a range with no numeric values.
  • A percentage or ratio computed before its denominator is filled in.

A formula that produces it

=1/0
#NUM!A number is invalid or the result is impossible to represent.#VALUE!An argument or operand has the wrong type.