SIGN Function Explained
The SIGN
function in Microsoft Excel returns the sign of a number. It takes a single argument, a number, and returns 1 if the number is positive, 0 if the number is 0, and -1 if the number is negative.
SIGN Function Syntax
SIGN(number)
- number: The number whose sign is to be returned. The number can be positive, negative, or zero.