NOT

Returns TRUE if the argument is FALSE. Returns FALSE if the argument is TRUE.

Sample Usage

NOT(TRUE)
NOT(FALSE)
NOT(C5)

Syntax

NOT(logical_expression)

  • logical_expression - An expression or reference to a cell containing an expression that represents some logical value. Each expression must be either TRUE or FALSE.

Examples

NOT(TRUE) returns a value of FALSE.
NOT(FALSE) returns a value of TRUE.

 Notes

  • The number 0 is logically false; all other numbers (including negative numbers) are logically true.