Spreadsheet formulas explained, side by side

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

AppSupportSyntax & notes
Excel✔ Built inNOT(logical)
Google Sheets✔ Built inNOT(logical_expression)
Airtable✔ Built inNOT(expression)
Notion✔ Built innot(condition)
Also written with the keyword: not condition.
Try NOT with your own values
Result (as Excel & Google Sheets return it)
TRUE
Your formula, ready to paste
Excel=NOT(45 >= 50) open excel.new ↗
Google Sheets=NOT(45 >= 50) open sheets.new ↗
AirtableNOT(45 >= 50)
Notionnot(45 >= 50)

TRUE means the order does not qualify for free shipping. total < threshold gives the same answer.

Arguments

ArgumentWhat it means
logicalA condition or TRUE/FALSE value to reverse.

Examples

FormulaResultWhyCopy
=NOT(TRUE)FALSE
=NOT(45>=50)TRUEThe comparison is FALSE, so NOT returns TRUE.
=NOT(ISBLANK(A2))TRUE if A2 has a valueA readable "is not empty" test.
=NOT(0)TRUENumbers 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.

Part of the Logical functions. Results in the tester follow Excel and Google Sheets behaviour; always double-check important work in your own file.