NOT

Overview

Description

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 when you want to invert an existing logical condition so true becomes false and false becomes true.

Syntax

NOT('Node')

Parameters

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

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

Input node: A

Formula: NOT('A')

Function	When to use instead
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.