Returns the NOT value of the values passed to the function.
= NOT1(value)
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) |
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.
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. |