ISERROR

Returns TRUE if the value is an error.

Sample Usage

ISERROR(C5)

Syntax

ISERROR(value)

• value - The value to be checked.
  

Examples

ISERROR(C5) evaluates to TRUE if the cell C5 has an error.

Notes

• ISERROR returns TRUE on any error, while ISERR returns TRUE on all errors except for '#N/A'.