SIGN

See also A-Z Spreadsheet Function List

Description Determines the sign of the specified number.

Syntax SIGN(number)

number is any number.

Remarks SIGN returns 1 if the specified number is positive, -1 if it is negative, and 0 if it is 0.

See Also ABS function

Examples SIGN(-123) returns -1

         SIGN(123) returns 1