OpenOffice3.org Calc 3. Mathematical Functions
SIGN(Number) Function
Determines the sign that has the argument
“Number”. This function returns 1, -1 or 0, depending on the sign of the number.
If argument “Number” contains a positive number it returns 1. If the argument
“Number” contains a negative number, it returns -1. Finally, if “Number” is 0,
the function returns 0. The argument “Number” can take any numerical value. For
example:
=SIGN(35) Returns 1, Indicates that the argument is positive.
=SIGN(-20) Returns -1, Because the argument is negative.
=SIGN(0) Returns 0. The argument is zero.