The NOT function returns the logical value True if the argument it receives is False, and vice versa.
Syntax
NOT(
logical
)
Parameters
- logical: Expression that returns a logical value True or False.
Returned value
The NOT function returns a Boolean.
Examples
This example shows a list of sales targeting amounts of € 100,000. In the third column, it is evaluated if sales have been less than this figure with the formula:
Venta < 100000 = Tabla1[Precio]<100000
...and, in the next column, it is evaluated if the objective has been reached using the NOT function:
Category
Logical