NOT1

Returns the NOT value of the values passed to the function.

Syntax

= NOT1(value)

Parameters

value

A value whose NOT is to be determined.  The value can be an expression (e.g., 1+1=2), a boolean (e.g., true), a string (“true”, “false”), or a number(-15)

Return Type

Boolean

In the case of an error, the function displays an error message: “NOT1(value): Error message”

The function can be used in combination with other functions.

Examples

Example

Returns

= NOT1(True)

False

= NOT1(2+1=2)

True

= NOT1(“True”)

False

= AND1(NOT1(Quantity > 10), Discount > 5)

True if the Quantity is lesser than or equal to 10 and the Discount is greater than 5.

= NOT1(OR1(Quantity > 10, Quantity < 15))

True if  the Quantity is not greater than 10 and is not lesser than 15.