ExcelFlux

NOT function

Reverses the logic of its argument.

Logical

Where can you use it?

Teams building reports and business rules. Adapt the example’s decision rule when you need to test a condition or display different results based on it.

Scenario in the workbook

Invert a control flag. Zero is treated as false.

A worked example from the workbook

RowA
6Input
7TRUE
8FALSE
90
Record 1
=NOT(A7)

Expected resultFALSE

See the inputs and instructions for all 3 examples

Copyable formulas

English Excel · en-US
=NOT(2=3)
Turkish Excel · tr-TR
=DEĞİL(2=3)

Expected result

TRUE

Worked examples

Invert a control flag. Zero is treated as false.

Open the English sheet. Inputs begin at A6. F7:F9 show the live results and G7:G9 show the original results for comparison.

Row A
6 Input
7 TRUE
8 FALSE
9 0
Case Formula Expected result
Record 1 =NOT(A7) FALSE
Record 2 =NOT(A8) TRUE
Record 3 =NOT(A9) TRUE
Microsoft Excel reference