NOT function


The Klipfolio NOT function inverts the specified value. Use the NOT function when you want to change a true to a false, or a false to a true.

The syntax for the NOT function is:

NOT ( values )


values A value that either evaluates to true or false. vector

NOT example

Let's look at a NOT function example.




1 Apples 10
2 Pears 20

The following example is based on the above text from an Excel spreadsheet:

SELECT( B:B , NOT( ( BETWEEN( B:B , 1 , 11 ))))  

-> [20]

You can also use the "not equals to" operator to achieve this result.

Related links: