# 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 IF function to return a value based on whether a condition is True or False.* 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

 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.