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.


Back to the list of mathematical functions