Syntax
NOT(condition)
Arguments
condition (Yes/No): An expression that results in TRUE or FALSE.
Return Value
Yes/No: The inverse of condition: TRUE if condition is FALSE, FALSE if condition is TRUE.
Examples
NOT(TRUE)
: FALSE
NOT(FALSE)
: TRUE
NOT(ISBLANK([Detail]))
: TRUE if the Detail column value is not blank. Equivalent to ISNOTBLANK([Detail])
. See also: ISBLANK(), ISNOTBLANK().
NOT(WEEKDAY(TODAY()) = "Sunday")
: TRUE if the today's weekday name is not Sunday. Equivalent to WEEKDAY(TODAY()) <> "Sunday"
. See also: TODAY(), WEEKDAY().
NOT(IN([Color]), {"Orange", "Red"})
: TRUE if the Color column value is not Orange or Red. Equivalent to AND(([Color] <> "Orange"), ([Color] <> "Red"))
. See also: AND(), IN().