NOT Function

🎯Purpose

Reverses the value of its argument. Use NOT when you want to make sure a value is not equal to a particular value. Returns TRUE if argument is FALSE; returns FALSE if argument is TRUE.

Syntax

EXCEL

=NOT(logical)

Arguments Breakdown

Argument	Required?	Description
`logical`	Required	A value or expression that can be evaluated to `TRUE` or `FALSE`.

Practical Examples

1. Inverting Boolean State Drill

From Formulas_&_Functions_Part_2.xlsx (Sheet Logical ):

EXCEL

=NOT(J27)

Where J27 is =OR(C27>80, C28>80). Inverts the outcome to flag non-qualifying cases.

2. Excluding Specific Status

EXCEL

=IF(NOT(Orders[Status] = "Cancelled"), Orders[Revenue], 0)

Related Knowledge

Notes: 03 Conditional Logic and Decision Making
Workbook: 11_Demos_and_Workbooks/03_Formulas_and_Functions/Formulas_&_Functions_Part_2.xlsx (Sheet: Logical )