NOT
Usage
Use this function to invert the result of boolean (true or false) expression
| Category | Function | Type | Where to use | Argument statement |
|---|---|---|---|---|
| FUNCTION | SERVER ROW | LOGICAL | .VALUE |
Syntax
1 | |
Arguments
Value
any cell value (#Storage_Name.Field_Name.VALUE or .OLDVALUE), constant, System Variables, or function-returned value
Notes
This function is mainly used as argument in SERVER function such as IF, AND, OR. It can be used also in CLIENT function such CELLIF, CELLAND, CELLOR if the VALUE argument is not depending on record's fields value
Return Value
Boolean
Examples
Examples 1
Formula
=NOT(
=CONTAINS(
=LIST($CURRENTUSER.GROUPNAMES);
"Manager")
)
Description
Check if the value list Manager is not contained in the Groups list of the current User (variable), so if the User is in the group Manager
Result
true or false