What it does
NOT takes a single condition and reverses its result: =NOT(ISBLANK(C2)) returns TRUE when C2 is filled. For simple comparisons you can just write the condition the other way round (B2<>"Cancelled"); NOT is most useful when the thing you want to reverse is the result of a function.
Combined with AND and OR, it is a short way of saying "none of these": =NOT(OR(B2="Cancelled",B2="Returned")) returns TRUE when the status is neither cancelled nor returned.
Given a number, NOT treats 0 as FALSE and any other number as TRUE, so =NOT(C2) returns TRUE when C2 is empty or 0. To test whether a cell is empty use ISBLANK; to test whether it holds a number use ISNUMBER.
Syntax
=NOT(logical)=DEĞİL(mantıksal)Arguments in square brackets are optional. English Excel separates arguments with commas (,) and uses a dot for decimals; Turkish Excel uses semicolons (;) and a decimal comma. Excel shows function names in its own language when it opens the file.
Arguments
| Argument | Required | Description |
|---|---|---|
logical | Required | The condition or value to reverse: ISBLANK(C2), B2>100, OR(…). |
Examples
1Flag invoices that have a payment date
ISBLANK returns TRUE when the payment date is empty; NOT reverses it, so invoices with a payment date become TRUE.
=NOT(ISBLANK(C2))| A | B | C | D | |
|---|---|---|---|---|
| 1 | Invoice | Amount | Payment Date | Paid? |
| 2 | F-2041 | 12,400.00 | 28-Oct-2026 | TRUE |
| 3 | F-2042 | 3,850.00 | FALSE | |
| 4 | F-2043 | 7,200.00 | 3-Nov-2026 | TRUE |
| 5 | F-2044 | 15,900.00 | FALSE |
- D2 (filled down to D5)
=NOT(ISBLANK(C2))
F-2041, which has a payment date, shows TRUE; the pending F-2042 shows FALSE. Enter a date in C3 and D3 changes by itself.
We recalculated this example in real Excel (Microsoft 365, 16.0) and compared the results: they match.
2Pick orders that are neither cancelled nor returned
An order counts as a sale if its status is neither "Cancelled" nor "Returned". OR catches either status and NOT reverses the result.
=NOT(OR(B2="Cancelled",B2="Returned"))| A | B | C | D | |
|---|---|---|---|---|
| 1 | Order | Status | Amount | Counts as Sale |
| 2 | SO-901 | Delivered | 3,200 | TRUE |
| 3 | SO-902 | Cancelled | 1,850 | FALSE |
| 4 | SO-903 | Shipped | 2,600 | TRUE |
| 5 | SO-904 | Returned | 1,450 | FALSE |
| 6 | SO-905 | Delivered | 4,100 | TRUE |
- D2 (filled down to D6)
=NOT(OR(B2="Cancelled",B2="Returned"))
The cancelled SO-902 and the returned SO-904 show FALSE; the others show TRUE. With this column, net sales come from one formula: =SUMIF(D2:D6,TRUE,C2:C6).
We recalculated this example in real Excel (Microsoft 365, 16.0) and compared the results: they match.
Common errors and fixes
- #VALUE!
Cause: The argument is text that cannot be read as a number or a logical value.
Fix: Give NOT a comparison or a function that returns TRUE or FALSE.
- Cell looks empty
Cause: The cell holds only a space; it looks empty, but ISBLANK sees it as filled and
NOT(ISBLANK(C2))returns TRUE.Fix: Clear the cell, or test with
TRIM(C2)<>"".
Good to know
- Avoid double negatives:
B2="Done"reads better thanNOT(B2<>"Done"). - The result of NOT can be added up:
=SUMPRODUCT(--NOT(ISBLANK(C2:C9)))counts the filled cells; COUNTA does the same more briefly.
In Nexell
Get Nexell to do it from a sentence
Add a Status column to the invoice list that says "Pending" where no payment date has been entered and "Paid" where it has
Convert to tableBring your invoice list into the tool and type this. Nexell adds the Status column with real Excel formulas and shows it in the preview; in the downloaded file, the status changes by itself once a payment date is entered.
Nexell uses AI to understand the request and builds the result with real Excel formulas; the formula may differ from the example on this page. You see a preview first and nothing changes until you press Apply; formulas stay live in the downloaded .xlsx file.
Free account · no card needed · 30 credits a month
Frequently asked questions
How do I write "not equal to" in Excel?
Use the <> operator in a comparison: =B2<>"Cancelled". =NOT(B2="Cancelled") gives the same result; to exclude several values, write =NOT(OR(B2="Cancelled",B2="Returned")).