ISERR

Returns TRUE if the value is an error other than ‘#NA’.

Sample Usage

ISERR(C5)

Syntax

ISERR(value)

• value - The value to be checked.
  

Examples

ISERR(C5) evaluates to TRUE if the cell C5 contains an error other than ‘#NA’.

Notes

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