ISERROR

See also A-Z Spreadsheet Function List

Description Determines if the specified expression returns an error value.

Syntax ISERROR(expression)

expression is any expression.

Remarks If the expression returns any error value (e.g., #N/A!, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!), True is returned. Otherwise, False is returned.

See Also ISBLANK , ISERR , ISLOGICAL , ISNA , ISNONTEXT , ISNUMBER , ISREF , and ISTEXT functions

Examples ISERROR(4/0) returns True

         ISERROR(A1) returns False if A1 contains a formula that does not return an error.