Excel #DIV/0! error: why it appears and how to hide or fix it

Fix division-by-zero errors in reports and averages without hiding real problems.

The message you see
#DIV/0!
Fastest fix

Upload the file and see exactly which rows cause the problem. Free, and the file stays in your browser.

Scan for text-numbers →

Why this happens

How to fix it

  1. 1Check whether the divisor should really be empty.
  2. 2Use =IF(B2=0,"",A2/B2) or =IFERROR(A2/B2,"") for expected empty cases.
  3. 3Convert numbers stored as text so averages see them.

Related guides

Still stuck? Ask SheetFix Support