Excel / 4 min read

How to Fix #DIV/0! Error in Excel

Handle division-by-zero errors in Excel by checking blank cells, zero denominators, and safe fallback logic.

Error text: #DIV/0!

A #DIV/0! error means the formula tried to divide by zero or by an empty cell that Excel treats as zero in that context.

Check this first

Inspect the denominator cell first.
Check whether blanks are being treated as zero.
Decide whether the right fallback is blank, zero, or text.
Use IF or IFERROR only after choosing the correct business meaning.

Working examples

Safe division with an empty result when denominator is zero

=IF(B2=0, "", A2/B2)

What #DIV/0! means

This is one of Excel's most literal errors. The denominator resolved to zero, so the math cannot continue. In practice, that often happens because source data is incomplete rather than because someone intentionally typed zero.

That is why the best fix depends on context. Sometimes blank is correct, sometimes zero is correct, and sometimes the error should stay visible until data is filled in.

A better fix than blanket IFERROR

IFERROR can hide too much. If the only expected issue is a zero denominator, check that denominator directly so the workbook still shows unrelated problems elsewhere.

Use IF when the specific condition is known.
Use IFERROR only when multiple error types are acceptable.
Document the fallback choice if other people rely on the workbook.

Preventing repeated errors

If the denominator comes from imported data, validate it near the source. It is easier to flag missing counts once than to wrap every downstream ratio formula individually.