Spread Formula Reference
Formula Functions / Functions M to Q / NOT
In This Topic
    NOT
    In This Topic

    This function reverses the logical value of its argument.

    Syntax

    NOT(value)

    Arguments

    Provide a numeric or logical value for the argument.

    Remarks

    If the specified value is zero, then the function returns TRUE. If the specified value is a value other than zero, then the function returns FALSE.

    Data Types

    Accepts boolean data (TRUE or FALSE). Returns boolean data (TRUE or FALSE).

    Examples

    NOT(A3)

    NOT(R1C2)

    NOT(D5>100)

    NOT(0) gives the result TRUE

    NOT(TRUE)gives the result FALSE

    NOT(12) gives the result FALSE

    Version Available

    This function is available in product version 1.0 or later.

    See Also

    AND | OR | Logical Functions