NOT function in Excel
NOT reverses TRUE and FALSE.
Syntax
=NOT(logical)
| Argument | Required? | What it is |
|---|---|---|
| logical | Required | The condition to reverse. |
Practise NOT in a live spreadsheet
There is no dedicated lesson yet. Browse all lessons.
Related logical functions
- IFReturns one value if a test is TRUE and another if FALSE.
- IFSChecks conditions in order and returns the first TRUE match.
- IFERRORReturns a fallback when a formula errors.
- IFNAReturns a fallback only for #N/A errors.
- SWITCHMatches an expression against a list of values.
- ANDTRUE if all arguments are TRUE.
- ORTRUE if any argument is TRUE.
- XORTRUE if an odd number of arguments are TRUE.