Description
The NOT function inverts the Boolean value of the specified condition(s). If the condition is TRUE, NOT returns FALSE, and if the condition is FALSE, NOT returns TRUE.
Usage
This function is used to invert the Boolean value of one or more conditions.
Syntax:NOT(condition1, condition2, [condition3], …)
Examples
- Check if a State is Not "Complete":
Returns TRUE if the State is not "Complete"; otherwise, it returns FALSE.NOT(#[State] = "Complete")
Inputs
| Argument | Data Type | Description |
|---|---|---|
| condition1 | Boolean | The first condition to invert. |
| condition2 | Boolean | The second condition to invert. |
| [condition3] | Boolean | (Optional) Additional conditions to invert. |
Returns
Type: Boolean
- Produces the inverted Boolean value of the specified condition(s).