SIGN function in Excel returns the arithmetic sign of a supplied number. If the number is positive, the SIGN function returns +1, if the number is negative, the function returns -1 and if the number is 0 (zero), the function returns 0.
Syntax of SIGN Function in Excel
SIGN (number)
number – The number from which the arithmetic sign to be
Example of SIGN Function in Excel
Formula
- Row number 2,3 and 4 have negative values so the SIGN Function returns -1
- Row number 5 have zero so the SIGN Function returns 0
- Row number 6 and 7 takes up Positive values so the SIGN Function returns 1
Result
Note: #VALUE! Error occurs if the supplied number argument is non-numeric.