Errors

Blanks, missing values, & errors

Error Cause
DIV/0! Dividing by zero.
VALUE! Nonsense data in a calculation.
REF! Referencing a cell that has been deleted.
NAME? Forgetting to quote a string.
NUM! Numbers being out of range.
N/A Missing value.
ERROR! Syntax problem in a formula.

=ISBLANK()
=COUNTBLANK(Range)
=NA() = #N/A
=ISERROR()
=ISERR()