ISERR, ISERROR

Syntax: |
ISERR(X) |

ISERROR(X) |

*X* = An expression

**ISERR** returns 1 if *X* is an expression or
cell reference which produces an error, otherwise it
returns 0.

**ISERROR** is identical to **ISERR** except that it also returns
1 if it references a **NA** (not available) value.

**Examples:**

**ISERR**(1) = 0

**ISERR**(3/0) = 1

**ISERROR**(SQRT(-1)) = 1

**ISERR**(NA()) = 0

**ISERROR**(NA()) = 1

**ISERROR**(**ISERROR**(3/0)) = 0

**ISERROR**(C1) = 0, where C1 = **PI()**

**Excel compatible functions:** ISERR, ISERROR

Grey Trout Software

02 March 2003