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.
* This function can be used to reverse the behaviour of other functions.
* This function is not case sensitive when matching text strings.
* This function does not support wildcards (? and *).
* The "logical" can be a conditional test, an array or a cell reference.
* If "logical" evaluates to True, then False is returned.
* If "logical" evaluates to False, then True is returned.
* If "logical" evaluates to 1, then False is returned.
* If "logical" evaluates to 0, then True is returned.
* If "logical" does not evaluate to either True or False, then #VALUE! 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	B
1	=NOT(OR(B4="green",B4="red")) = True	5
2	=NOT(OR(B4="green",B4="blue")) = False	10
3	=NOT(FALSE) = True	some text
4	=NOT(TRUE) = False	blue
5	=NOT(1) = False
6	=NOT(0) = True
7	=NOT(1+1=2) = False
8	=NOT(5<10) = False
9	=NOT(5=10) = True
10	=NOT(5>10) = True
11	=NOT("SOME TEXT"="some text") = False
12	=IF(NOT(FALSE),"True","False") = True
13	=NOT(ISBLANK(B5)) = False
14	=NOT("some text") = #VALUE!

1 - Is the value in cell "B4" not green or red.
2 - Is the value in cell "B4" not green or blue.
3 - What is the opposite of False.
4 - What is the opposite of True.
5 - What is the opposite of the value 1.
6 - What is the opposite of the value 0.
7 - What is the opposite when the expression (1+1=2) gets evaluated.
8 - What is the opposite when the expression (5<10) gets evaluated.
9 - What is the opposite when the expression (5=10) gets evaluated.
10 - What is the opposite when the expression (5>10) gets evaluated.
11 - What is the opposite when two text strings are compared. This function is not case sensitive.
12 - This function is often combined with the IF function.
13 - This function returns True when the cell "B5" is not empty.
14 - This function returns #VALUE! if the argument does not evaluate to True or False.