SIGN returns a value that indicates whether a specified number is less than, equal to, or greater than 0 (zero):
SIGN
-1 if n < 0
-1
n < 0
0 if n = 0
0
n = 0
1 if n > 0
1
n > 0
Return Value
NUMBER
Syntax
SIGN(n)
Arguments
n is a numeric expression.
n
Example
SIGN(-15) returns the value -1.
SIGN(-15)