NOT()

Is it false?

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

Was this helpful?
How can we improve it?
Search
Clear search
Close search
Google apps
Main menu
Search Help Center
false