[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

ISERR

Syntax:

ISERR ( value )

Description: Determines if value is any of the error values other than #N/A.

Arguments:

Name

Type

Description

value

any

The value to be tested. No conversion shall take place on an argument passed to this function.

 

Return Type and Value: logical – TRUE if value is one of the error values, excluding #N/A; otherwise, FALSE.

[Example:

ISERR(A1) results in TRUE if A1 evaluates to #DIV/0!, for example
ISERR(B1) results in FALSE if B1 evaluates to #N/A

end example]