Tests to see if a condition is not met.
Syntax
NOT(x)
where:
- x: Line item to test
Format
| Input Format | Output Format |
|---|---|
|
x: Number, Boolean, date, time period, list item, text |
Boolean |
Arguments
The function uses the following arguments:
|
Number: Numeric line item, property, or expression |
| Boolean: Expression that equates to a Boolean result | |
| Hard-coded date, date variable, or line item—Time period |
Constraints
The function has the following constraints:
- The result cell must be formatted as a Boolean check box - The check box is checked if TRUE.
Excel equivalent
Example
The example below tests to see if the condition is NOT met. The result is shown in a Boolean check box that is TRUE if x is not greater than 1500.
NOT (x > 1500)
