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