NOT

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:

NOT function. Example of use

Category
Logical
Submitted by admin on Tue, 12/04/2018 - 12:58