NOT(logical)

Returns the opposite of a True or False value.


logicalThe 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.
* For the Microsoft documentation refer to support.office.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


© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top