#DIV/0! Error in Excel

#DIV/0! means the denominator is zero or blank. Common in ratios, margins, and percent-of-total formulas.

=A2/B2   → #DIV/0! when B2 is 0 or blank

Clean fixes

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

IFERROR also hides #VALUE! and #REF!. Prefer IF(B2=0,...) on dashboards so real bugs still show.