NOT

The NOT function in Shedmate inverts the logical value of a condition. It returns TRUE if the original condition is false and FALSE if the original condition is true. It is useful for checking the opposite of a condition within an IF formula.

Syntax:

IF(NOT(condition), value_if_true, value_if_false)

Parameters:

condition (required): The condition to be inverted. It can be any expression that results in true (TRUE) or false (FALSE).

value_if_true (required): The value to be returned if the inverted condition is true.

value_if_false (required): The value to be returned if the inverted condition is false.

Usage example: