Formulas > =NOT()
How to Use NOT() in Google Sheets
Description
How To Actually Use NOT() in Sheets
NOT(logical_expression)
Try NOT yourself
In cells A1:A10, enter TRUE or FALSE values. In cell B1, use the NOT formula to invert the logical value in A1. Drag the formula down to B10 to apply it to the rest of the range.
Hints (2)
-
Remember, NOT takes a single logical value as input.
-
You can drag the fill handle to apply the formula to other cells.
3 Better Sheets Tutorials
Tic Tac Toe In A Google Sheet
Figure out who won a game of tic tac toe. inside a Google Sheet. Great for teachers and educators.
AND()
COUNTA()
FILTER()
IF()
IFERROR()
+4 more
Create a Radio Button From Checkboxes Using Google Apps Script
Let's code a Radio button that turns off all checkboxes except the one clicked.
IFS()
NOT()
OR()
Restrict Access to a Cell if Another Cell is Blank
Having trouble with ppl filling in cells before other cells?
ISBLANK()
NOT()
Learn more about the NOT() formula:
Generate a NOT() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses NOT(). 2 free AI generations, no signup. Members get unlimited use.
Generate a NOT() formula