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

Was this helpful?

How can we improve it?

Need more help?

Try these next steps:

true
Search
Clear search
Close search
Google apps
Main menu