NOT

In Logical functions

The NOT function inverts the input values with the logical NOT operation. If the input is true (non-zero), false (0) is returned, and true (1) otherwise.

Use this function when you want to invert an existing logical condition so true becomes false and false becomes true.

Parameters

NodeNode referenceRequired

Input node, specified using the node name in single quotes (e.g. 'Profit').

Example

Typical use

This example shows that NOT turns non-zero values into 0 and turns 0 into 1.

Input node: 'A'

Formula: NOT('A')

See also

TRUE

When you need a constant true condition instead of inverting an existing logical result.

IS_NA

When you want to detect undefined values instead of inverting true and false results.