NOT

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.
* 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
* For the Google documentation refer to support.google.com

 AB
1=NOT(OR(B4="green",B4="red")) = True5
2=NOT(OR(B4="green",B4="blue")) = False10
3=NOT(FALSE) = Truesome text
4=NOT(TRUE) = Falseblue
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.

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