Return the reverse of TRUE or FALSE statements based on testing logical conditions
=NOT(logical)
Return the reverse of TRUE or FALSE statements based on testing logical conditions.
Return TRUE if the return is FALSE and FALSE if the return is TRUE.
NOT syntax requires 1 argument, a logical condition.
NOT examples.
In the examples below, the NOT function is used to test different logical conditions.
Use the NOT function to return the reverse of TRUE or FALSE statements based on testing logical conditions.
Syntax
NOT(logical)
The NOT function consists of 1 argument:
- logical. Required. A value or expression that can be evaluated to TRUE or FALSE.
Try it now!
- Enter your formulas into the grey cells.
Scope
NOT can be inserted into calculations to return the reverse of the TRUE and FALSE statements.
|
=NOT(AND(C2="Red",C3="Blue")) || result is FALSE if cell C2 contains the text string "Red" and C3 "Blue" |
|
=NOT(AND(1=1,2=2)) || result is FALSE as 1=1, 2=2 are indeed TRUE |
|
=NOT(AND(2/1/2022>1/1/2022,"3-Jan-2022">"2-Jan-2022")) || result is FALSE for both serial number and text string dates |
|
=NOT(AND(TRUE,TRUE)) || result is FALSE |
|
=NOT(AND(TRUE,FALSE)) || result is TRUE |
Caveats
- The logical condition (logical) or references must return TRUE or FALSE.
Related Functions
- AND() returns TRUE or FALSE statements based on testing multiple logical conditions.
- OR() returns TRUE or FALSE statements if either logical condition is met.
Functions Category