Click here for great value web hosting.

ALL ABOUT OFFICE

HOME

ACCESS

EXCEL

WORD

OUTLOOK

POWERPOINT




Search for
 

help


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