SIGN

Returns -1 if number is negative, 0 if number is 0, and 1 if number is greater than 0.

Syntax

SIGN(number)

Arguments

number -  any number.

Examples

SIGN(-24.34) = -1

SIGN(0) = 0

SIGN(3.14) = 1