NOT Function in Excel, Google Sheets, Airtable & Notion
NOT reverses a logical value: NOT(TRUE) is FALSE and NOT(FALSE) is TRUE. Use it to flip a test you already have.
Syntax in each app
| App | Support | Syntax & notes |
|---|---|---|
| Excel | ✔ Built in | NOT(logical) |
| Google Sheets | ✔ Built in | NOT(logical_expression) |
| Airtable | ✔ Built in | NOT(expression) |
| Notion | ✔ Built in | not(condition)Also written with the keyword: not condition. |
| Excel | =NOT(45 >= 50) | open excel.new ↗ |
|---|---|---|
| Google Sheets | =NOT(45 >= 50) | open sheets.new ↗ |
| Airtable | NOT(45 >= 50) | |
| Notion | not(45 >= 50) |
Excel & Sheets use cell ranges. Paste this sample data into cell A1 of a blank sheet, then paste the formula into any empty cell.
TRUE means the order does not qualify for free shipping. total < threshold gives the same answer.
Arguments
| Argument | What it means |
|---|---|
logical | A condition or TRUE/FALSE value to reverse. |
Examples
| Formula | Result | Why | Copy |
|---|---|---|---|
=NOT(TRUE) | FALSE | ||
=NOT(45>=50) | TRUE | The comparison is FALSE, so NOT returns TRUE. | |
=NOT(ISBLANK(A2)) | TRUE if A2 has a value | A readable "is not empty" test. | |
=NOT(0) | TRUE | Numbers count as logical values: 0 is FALSE, anything else TRUE. |
Examples use Excel / Google Sheets syntax unless noted.
How NOT works
NOT is most useful with functions that answer a yes/no question: NOT(ISBLANK(A2)), NOT(ISNUMBER(A2)), NOT(ISERROR(A2)). For simple comparisons it is usually clearer to flip the operator instead — A2<>"Done" rather than NOT(A2="Done"), or B2<50 rather than NOT(B2>=50).
Combined with AND and OR, NOT lets you express "none of these": =NOT(OR(A2="CA", A2="NY")) is TRUE when A2 is neither CA nor NY. Not-equal is written <> in Excel and Google Sheets, but != in Airtable and Notion.
Frequently Asked Questions
- How do I write "not equal to"?
- Use
<>in Excel and Google Sheets (=A2<>"Done") and!=in Airtable and Notion.