ISERR

Description

ISERR determines if the specified expression returns an error value.

Syntax

ISERR ( expression )

 

Parameter

Description

expression

Any expression.

Remarks

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

Example

This function returns True if A1 contains a formula that returns an error such as #NUM!:

ISERR(A1)

Also, see

ISBLANK

ISERROR

ISLOGICAL

ISNA

ISNONTEXT

ISNUMBER

ISREF

ISTEXT