Documentation/Calc Functions/SIGN
TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate
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.
Examples:
| Formula | Description | Returns |
|---|---|---|
| =SIGN(3.4) | Here the function returns 1 to indicate that the specified number is positive. | 1 |
| =SIGN(D1) where cell D1 contains the number -4.5. | Here the function returns -1 to indicate that the specified number is negative. | −1 |
| =SIGN(0) | Here the function returns 0, to indicate that the specified number is equal to zero. | 0 |
Related LibreOffice functions:
ODF standard:
Related (or similar) Excel functions:
SIGN