Comment on page

Logical-not !, not

Operator: ! , not
The logical operator ! , not can be used to inverse a logical condition or boolean value (Yes/No). If the condition evaluates to unknown, the inverse is also (still) unknown.
The operators ! and not can both be used and are exactly the same.
This function is SQL compatible. For more information about SQL compatibility, see our documentation.
Returns a value that is the inverse of the original condition.
!True => No
! (true or false) => No
! (true and false) => Yes
! (unknownboolean) => unknown
! 123 => expression type mismatch
not condition
not True => No
not (true or false) => No
not (true and false) => Yes