1. Calculation functions
  2. All Functions
  3. Logical Functions
  4. IF NOT

Tests whether condition is not true.

Syntax

IF NOT (x) THEN 1 ELSE 0

where:

  • x: Boolean argument to test

Back to Top

Format

Input Format Output Format
Boolean Binary

Back to Top

Arguments

The function uses the following arguments:

  • x: Expression that equates to a Boolean result.

Back to Top

Constraints

The function has no constraints.

Back to Top

Excel equivalent

Back to Top

Example

IF NOT (a > 1500) THEN 1 ELSE 0

Returns 1 if line item a is less than 1500 (not greater than), returns 0 if line item a is greater than 1500.

Back to Top

Similar functions