[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

ISERROR

Syntax:

ISERROR ( value )

Description: Determines if value is any of the error values.

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; otherwise, FALSE.

[Example:

ISERROR(A1) results in TRUE if A1 evaluates to #DIV/0!, for example

end example]