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()