Better Sheets

How to Use NOT() in Google Sheets

Description

Returns the opposite of a logical value - `NOT(TRUE)` returns `FALSE`; `NOT(FALSE)` returns `TRUE`.

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.

Your formula

Hints (2)

Locale Separator ,

Official Docs

Better Sheets Tutorial

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.

Data validation Advanced

IFS() NOT() OR()

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

Restrict Access to a Cell if Another Cell is Blank

Having trouble with ppl filling in cells before other cells?

Data validation Beginner

ISBLANK() NOT()

Transcript-matched member videos for NOT(). Click through to watch.

Watch more tutorials

Hardest Formula: SumIF | Addition Based on Dates / Values

Demystifying the SumIF Formula. Add up your values based on a condition,...

SUMIF() UNIQUE()

Calculate ROAS in Google Sheets

Calculate Return on Ad Spend with a formula combination. Bonus: create a...

Intermediate

CONCATENATE() ROUND()

Learn Google Sheet Formulas The Hard Way

One weird way to learn more about what Google Sheets can do. https://bet...

Google Sheet Basics - The Absolute Basics

Let's start at the basics of Google Sheets. Where every beginner spreads...

Beginner

Unlock these tutorials

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