Returns the sign of a given number. Returns 1 for a positive number, -1 for a negative number, and 0 (zero) if the number is 0.
Sample Usage
SIGN(10)
SIGN(-10)
SIGN(C5)
Syntax
SIGN(number)
- number - The number for which the sign is to be examined.
Examples
SIGN(10) returns the sign of 10 i.e 1.
SIGN(-10) returns the sign of 10 i.e -1.
SIGN(C5) returns the tangent of the number contained in C5.