next up previous contents index
Next: NOW Up: A. Function Reference Previous: NOR   Contents   Index


NOT, XLNOT

Syntax: NOT(X)
  XLNOT(X)

X = a numeric value

NOT returns 1 if X=0; 0 if X=1; otherwise -1 (unknown).

XLNOT returns 1 if X=0, or 0 if X is non-zero. XLNOT is compatible with Excel's NOT function.

Examples:

A1 = 1, B1 = 1, C1 = 0, D1 = 0, E1 = 1 and A2 = 24

NOT(A1) = 0

XLNOT(A1) = 0

NOT(A2) = -1

XLNOT(A2) = 0

NOT(C1) = 1

XLNOT(C1) = 1

NOT(C1) = 1 (in Excel compatibility mode)

Excel function: XLNOT is compatible with Excel's NOT (In Excel compatibility mode, the ``XL'' prefix is not used.)


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