NOT()

Returns a Yes/No expression as follows:

• TRUE if condition is FALSE
• FALSE if condition is TRUE

Sample usage

NOT(TRUE)  returns  FALSE

NOT(FALSE)  returns  TRUE

NOT(ISBLANK([Detail]))  returns  TRUE if the Detail column value is not blank. Equivalent to ISNOTBLANK([Detail]) . See also: ISBLANK() , ISNOTBLANK()

NOT(WEEKDAY(TODAY()) = "Sunday")  returns  TRUE if the today's weekday name is not Sunday . Equivalent to WEEKDAY(TODAY()) <> "Sunday" . See also: TODAY() , WEEKDAY()

NOT(IN([Color]), {"Orange", "Red"})  returns  TRUE if the Color column value is not Orange or Red . Equivalent to AND(([Color] <> "Orange"), ([Color] <> "Red")) . See also: AND() , IN()

Syntax

NOT( condition )

• condition  - A Yes/No expression that results in TRUE or FALSE .

See Also

AND()

OR()