Excel Function NOT

NOT(logical)

Returns the opposite of a True or False value.

logical

The value or expression that can be evaluated to True or False.

Remarks

* This function returns either True or False.
* This function can be used when you want to return the opposite logical value.
* The "logical" can be a conditional test, an array or a cell reference.
* If "logical" evaluates to False, then True is returned.
* If "logical" evaluates to True, then False is returned.
* You can use the AND function to return the logical AND for any number of arguments.
* You can use the OR function to return the logical OR for any number of arguments.
* You can use the XOR function to return the logical exclusive OR for any number of arguments.
* The equivalent VBA operator is VBA.NOT
* For the Microsoft documentation refer to support.microsoft.com

	A
1	=NOT(FALSE) = True
2	=NOT(TRUE) = False
3	=NOT(1+1=2) = False
4	=NOT(5<10) = False
5	=NOT(5=10) = True
6	=NOT(5>10) = True
7	=IF(NOT(FALSE),"True","False") = True