NOT Function in Excel: Reverse TRUE and FALSE

📎 This article includes 1 downloadable practice file ↓

LogicalLevel: BeginnerAvailable in: Excel 2007+

In this article

1. Syntax
2. Examples
3. Example 1
4. Example 2
5. NOT in practice
6. Where you will use it
7. Worked example
8. Mistakes people make
9. Related functions
10. Continue learning

NOT flips TRUE to FALSE and back — useful for “everything except” conditions.

Syntax

=NOT(logical)

Argument	What it means
logical	A TRUE/FALSE value or test.

Examples

Example 1

=NOT(ISBLANK(C2))

TRUE when C2 has something.

Example 2

=IF(NOT(OR(B2="Delhi",B2="Mumbai")), "Non-metro", "Metro")

Everything except the listed cities.

NOT in practice

Where you will use it

• Reverse a condition: not yet paid
• Exclude items in conditional formatting
• Make ISBLANK into 'is filled'

Worked example

Paid?	Formula	Result
TRUE	=NOT(A2)	FALSE
FALSE	=NOT(A3)	TRUE
(blank)	=NOT(A4)	TRUE

Results calculated in Excel.

Mistakes people make

Mistake	What to do instead
Using NOT on text	NOT needs TRUE/FALSE or numbers
Double negatives in IFs	Rewrite the condition positively when possible

Related functions

AND · OR · IF

📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.

Continue learning

All Logical guides →

TRUE Function in Excel: The Logical Value TRUETRUE() returns the logical value TRUE. You can also just type TRUE; the function…FALSE Function in Excel: The Logical Value FALSEFALSE() returns the logical value FALSE, most often seen as the exact-match argument in…MAKEARRAY Function in Excel: Generate a Grid From Row and Column NumbersMAKEARRAY builds an array of a given size, computing each cell from its row…BYCOL Function in Excel: Apply a Calculation to Each ColumnLogicalLevel: ExpertAvailable in: Excel 365 / 2021+BYCOL is BYROW turned sideways: one result per…

📎 Practice files for this article

• 📗
  Practice workbook: Logic, LET & LAMBDA17 tasks on realistic sales data — type your formula, the Check column turns green when it is right. Answers sheet included.
  ⬇ XLSX · 35 KB

Free to use for learning. Files with macros (.bas) are plain text — import them with Alt+F11 → File → Import File, and always test on a copy.