How do I use NOT in Excel?
Use NOT when you want to reverse a TRUE/FALSE result. Enter Logical test in that order, then add optional arguments when needed.
Excel Function
NOT
Reverses a logical value.
NOT(logical)Arguments
logical
RequiredEnter a condition expression that returns TRUE/FALSE.
Practice Preview
Use NOT to reverse the result of whether cell B2 (Score in column B) is greater than or equal to 80.
Example Table
| # | ALearner ID | BScore | CAttendance Rate | DCondition Check |
|---|---|---|---|---|
| 2 | U001 | 82 | 96 | |
| 3 | U002 | 67 | 87 | |
| 4 | U003 | 91 | 99 | |
| 5 | U004 | 55 | 72 | |
| 6 | U005 | 78 | 90 | |
| 7 | ||||
| 8 |
How to Use (Formula)
=NOT(B2>=80)Result
FALSE
Practice This Function
NOT FAQ
Where can I practice NOT?
Use the "Start Function Practice" button to jump straight into NOT drills.
What arguments does NOT use?
The main arguments are Logical test. Enter them in order.