NOT
Flips a condition: TRUE becomes FALSE and vice versa. Helps you pick everything except canceled orders or empty cells.
NOT(logical)- logical
- The condition to flip.
Return value
The opposite value: FALSE instead of TRUE and TRUE instead of FALSE.
Examples
Which orders go into the report
fx
A
B
C
D
1
2
3
4
5
6
7
8
Order
Status
In report
ORD-2301
Delivered
ORD-2302
Canceled
ORD-2303
In transit
ORD-2304
Delivered
ORD-2305
Canceled
Sheet1
Details
NOT takes one condition and returns the opposite answer. NOT(B2="Canceled") gives TRUE for all orders except canceled ones.
A simple “not equal” is easier to write with the <> sign: B2<>"Canceled" works the same way. NOT is useful when you need to flip a function, for example NOT(ISBLANK(C2)): “the cell is filled”.
Common mistakes
- NOT takes only one condition. To flip several, combine them first: NOT(OR(...)).
- A double negative like NOT(B2<>"Canceled") is easy to misread. When you can, write the condition directly.