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.