The SIGN function returns the sign of a number (whether it's positive, negative, or zero). The SIGN function returns 1 for positive numbers, 0 for zero, and -1 for negative numbers.
SIGN(Number)
Arguments
| Argument | Data type | Description |
| Number | Number | The number to determine the sign of. |
The SIGN function returns a number.
Excel equivalent
Examples
| Formula | Result |
SIGN(100) | 1 |
SIGN(0) | 0 |
SIGN(-10) | -1 |