Determines the sign of a number. Returns 1 if the number is positive, zero (0) if the number is 0, and -1 if the number is negative.
Syntax
SIGN(number)
Number is any real number.
Example
| Formula | Description (Result) |
|---|---|
| =SIGN(10) | Sign of a positive number (1) |
| =SIGN(4-4) | Sign of zero (0) |
| =SIGN(-0.00001) | Sign of a negative number (-1) |