NOT function
NOT flips a logical value, returning TRUE when the input is FALSE and FALSE when it is TRUE. It is handy for reading a test the other way round.
Example
Read it as a sentence: flip the TRUE or FALSE in F1. F1 is empty, which counts as FALSE, so the answer is TRUE.
Excel shows TRUE
F
1
Data
Syntax
NOT(logical)
-
logical(required) - A value or condition to reverse.
Returns: TRUE if the input is FALSE, and FALSE if it is TRUE.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=NOT(TRUE) | FALSE | True |
=NOT(0) | TRUE | Zero |
=NOT(5) | FALSE | Nonzero |
=NOT("TRUE") | FALSE | Text TRUE |
=NOT({TRUE,FALSE}) | FALSE | Array spills |
=NOT(Data!F1) | TRUE | Blank |
=NOT("a") | #VALUE! | Text |
=NOT(Data!F2) | #VALUE! | Text number cell |
The Data sheet these formulas read
A cell that starts with = holds that formula.
F
1
2
'123
Data
Watch out for
- For "not equal" you can use <> instead.
Where it works
- Excel
- NOT is in every version of Excel from 2007 on.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Logical functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .