SIGN
Determines whether a number is positive.
Syntax
SIGN(Value)
Value is a number or a formula that
returns a number. The function returns 1 if Value is
positive, -1 if Value is negative and 0 if Value is 0.
Example
This example returns -1:
SIGN(-3.4)