Skip to content

Excel function · Logical

Excel NOT function

NOT reverses a logical value: TRUE becomes FALSE and FALSE becomes TRUE. Use it for conditions phrased in the negative, such as "has a payment date been entered?" or "is it neither cancelled nor returned?".

In Turkish Excel: DEĞİL

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

English Excel=NOT(logical)
Turkish Excel=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

ArgumentRequiredDescription
logicalRequiredThe 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.

D2fx=NOT(ISBLANK(C2))
Flag invoices that have a payment date: example table
ABCD
1InvoiceAmountPayment DatePaid?
2F-204112,400.0028-Oct-2026TRUE
3F-20423,850.00FALSE
4F-20437,200.003-Nov-2026TRUE
5F-204415,900.00FALSE
  • 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.

D2fx=NOT(OR(B2="Cancelled",B2="Returned"))
Pick orders that are neither cancelled nor returned: example table
ABCD
1OrderStatusAmountCounts as Sale
2SO-901Delivered3,200TRUE
3SO-902Cancelled1,850FALSE
4SO-903Shipped2,600TRUE
5SO-904Returned1,450FALSE
6SO-905Delivered4,100TRUE
  • 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 than NOT(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

Type this in Nexell

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 table

Bring 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")).

Related functions

All logical functions →

Stop memorising formulas. Describe them.

Bring your table into the tool and say what you need; Nexell builds the formula and shows it in a preview.

Try it free