#DIV/0! error

Excel glossary definition

A formula tried to divide by zero or by an empty cell.

Definition

Wrap risky divisions in IFERROR or check the divisor first: =IF(B2=0, 0, A2/B2).

Back to Excel glossary