Google Sheets
NOT function in Google Sheets
Returns the opposite of a logical value - `NOT(TRUE)` returns `FALSE`; `NOT(FALSE)` returns `TRUE`.
=NOT(logical_expression)NOT syntax and parameters
One argument, one required.
- logical_expressionbooleanRequired
An expression or reference to a cell holding an expression that represents some logical value, i.e. TRUE or FALSE.
NOT examples
Formulas you'll actually reuse.
TRUE when a ship date has been filled in:
=NOT(ISBLANK(E2))Result
TRUEAmount for every region except West, zero otherwise:
=IF(NOT(A2 = "West"), D2, 0)Result
0
NOT in Excel
Same name — your formula ports as-is.
Try NOT in the playground
Edit the example — nothing to install.
Preloaded with the NOT formula from Example 1 — change anything and watch it respond.
Loading the editor…
Related functions
More ways Google Sheets gets this done.
- ANDReturns true if all of the provided arguments are logically true, and false if any of the provided arguments are logically false.LogicalExcel
- FALSEReturns the logical value `FALSE`.LogicalExcel
- IFReturns one value if a logical expression is `TRUE` and another if it is `FALSE`.LogicalExcel
- IFERRORReturns the first argument if it is not an error value, otherwise returns the second argument if present, or a blank if the second argument is absent.LogicalExcel
- IFNAEvaluates a value. If the value is an #N/A error, returns the specified value. .LogicalExcel
- IFSEvaluates multiple conditions and returns a value that corresponds to the first true condition.LogicalExcel