next up previous contents index
Next: ISNUMBER Up: A. Function Reference Previous: IRR   Contents   Index


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


next up previous contents index
Next: ISNUMBER Up: A. Function Reference Previous: IRR   Contents   Index
SpreadScript User's Guide, Version 1.2
Grey Trout Software
02 March 2003