ISERR

See also A-Z Spreadsheet Function List

Description Determines if the specified expression returns an error value.

Syntax ISERR(expression)

expression is any expression.

Remarks If the expression returns any error except #N/A!, True is returned. Otherwise, False is returned.

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

Example ISERR(A1) returns True if A1 contains a formula that returns an error (e.g., #NUM!).