ExcelHeroThe NOT function
Turns TRUE into FALSE and FALSE into TRUE.
In German Excel: NICHT
How to write it
=NOT(logical)- logical
- A test or TRUE/FALSE value.
💡 NOT(D3=0) is the same as D3<>0.
Try it
Is the notebook not sold out? Use NOT.
A
B
C
D
E
1
Code
Product
Price
Stock
Available
2
P-101
Desk lamp
24.99
12
3
P-102
Notebook
3.5
240
4
P-103
Backpack
39.9
0
5
P-104
Water bottle
12
55
6
P-105
Headphones
59
8
NOT(stock = 0).