Home / Error Lookup / #DIV/0!

#DIV/0!

Excel #DIV/0! Error Applies to: Windows 7, Windows 10, Windows 11

What it means

The formula is dividing by zero or by an empty cell.

Also seen as: #DIV/0!, divide by zero

Quick fix steps

  1. Check the denominator cell — if it's meant to have a value, fill it in.
  2. Wrap the formula in IFERROR(), e.g. =IFERROR(A1/B1, 0), to show a clean result instead of the error when the denominator is empty.
  3. If zero is a valid, expected value in some rows, use an IF() check before dividing rather than suppressing the error entirely.
For the full step-by-step walkthrough, see Understanding Excel Formula Errors (#REF!, #VALUE!, and More).

Frequently Asked Questions

Does this mean my formula is wrong?
Not necessarily your formula's logic — it means one of the cells it depends on is currently empty or zero, which the formula correctly flags rather than silently producing a wrong number.
How do I prevent this from showing up when a cell is legitimately empty sometimes?
Wrapping the formula in IFERROR lets you display something else (like a blank or a custom message) instead of the #DIV/0! error when the denominator is genuinely expected to be empty sometimes.

Other error codes

#REF! — #REF! Error

A formula is pointing to a cell that no longer exists — usually because a row, column, or sheet it referenced was deleted.

#VALUE! — #VALUE! Error

The formula received the wrong type of data — commonly text where it expected a number.

#N/A — #N/A Error

A lookup formula (VLOOKUP, MATCH, XLOOKUP, INDEX/MATCH) couldn't find a matching value.

#NAME? — #NAME? Error

Excel doesn't recognize text used in the formula — most often a misspelled function name or a missing quotation mark.