Overview
Grammar | SIGN(number) | Returns the sign of a number. Returns 1 for positive numbers, 0 for zero, and -1 for negative numbers. |
Parameter | number | Any real number. |
Notes
The function supports only one numerical parameter.
Example
Formula | Result | Notes |
---|---|---|
SIGN(10) | 1 | |
SIGN(4-4) | 0 | |
SIGN(-0.00001) | -1 |