Tests whether condition is not true.
Syntax
IF NOT (x) THEN 1 ELSE 0
where:
- x: Boolean argument to test
Format
| Input Format | Output Format |
|---|---|
| Boolean | Binary |
Arguments
The function uses the following arguments:
- x: Expression that equates to a Boolean result.
Constraints
The function has no constraints.
Excel equivalent
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.