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.)

Grey Trout Software

02 March 2003