Skip to content
Excel

NOT function in Excel

Reverses the logic of its argument

=NOT(logical)

NOT syntax and parameters

One argument, one required.

  • logicalbooleanRequired

    A value or expression that can be evaluated to TRUE or FALSE.

NOT examples

Formulas you'll actually reuse.

  1. TRUE when a ship date has been filled in:

    =NOT(ISBLANK(E2))

    ResultTRUE

  2. Amount for every region except West, zero otherwise:

    =IF(NOT(A2 = "West"), D2, 0)

    Result0

NOT in Google Sheets

Same name — your formula ports as-is.

Try NOT in the playground

Edit the example — nothing to install.

Preloaded with the NOT formula from Example 1 — change anything and watch it respond.

Loading the editor…

Related functions

More ways Excel gets this done.