← Back to level 1
Level 1Next
NOT
A easy logic formula that reverses a TRUE/FALSE result when you need the opposite condition.
Syntax
=NOT(...)Step-by-step explanation
- 1List the logical tests that NOT should evaluate before you finish the formula.
- 2Use NOT when you need all conditions to be true, any condition to be true, or the result to be reversed.
- 3Check the final TRUE or FALSE output against a simple test case before copying it down.
Common mistakes
Forgetting that NOT flips the result instead of checking a new rule
Using it where AND or OR is more readable
Passing in a non-logical test without understanding the output
Example table
A quick scenario to connect the syntax to the result.
| 12 | 18 |
| 8 | 42 |
Formula
=NOT(A1:B2)
Result
42
Worked example
- 1Read the sample data first so you know what the formula needs to solve.
- 2Enter =NOT(A1:B2) in the result cell and press Enter.
- 3Check that the output matches 42.
Practice area
Use NOT when you want to flip a test, such as turning blank into not blank or active into not active.
Match against the syntax block above.