EXCEL
Error Numbers
Excel treats seven error values as
if they were numbers:
DIV/0!

Division by zero

#NAME

A variable name in a formula
has not been defined

#N/A

No value is available

#NULL!

A result does not exist, or is
an invalid intersection of two areas

#NUM!

Numeric overflow, underflow,
or incorrect use of a number, such as SQRT(1).

#REF!

Invalid cell reference;
the cell is not on the worksheet

#VALUE!

Invalid argument type, such as
text where a number is required

If you see one of these values in a
cell you will need to check the values in the formula and the cells referenced
by that formula to see where the error has come from.
The auditing tools can help you find the
related cells.
Click here to
return to the Excel index.
webmaster@allaboutoffice.co.uk 