Documentation/Calc Functions/SIGN/en

Function name:
SIGN

Category:
Mathematical

Summary:
Determines the sign of a number.

Syntax:
SIGN(Number)

Returns:
Returns 1 if the number is positive, -1 if the number is negative, and 0 if the number is equal to zero.

Arguments:
Number is a real number, or a reference to a cell containing that number, whose sign is to be determined.


 * If Number is non-numeric, then SIGN reports a #VALUE! error.

Additional details:
The figure below illustrates the SIGN function.

Related LibreOffice functions:
ABS

ODF standard:
Section 6.16.54, part 2

Equivalent Excel functions:
SIGN