Using the Excel SIGN Function

Summary
SIGN is used to return the sign of a number. If the number is positive, 1 is returned. If the number is negative, -1 is returned. Zero (0) is returned if the number is zero.Syntax
=SIGN (number)Syntax Breakdown
NumberRequired. Number can be any real number. You can also enter equations for this argument.
Usage Notes
SIGN returns the sign of a given number as follows:- -1 if number is in the range of (-∞,0).
- 0 if number is zero (0).
- 1 if number is in the range of (0,∞)
SIGN Errors
The number argument for SIGN must be a real number. Other entries will result in the function returning the #VALUE! error.
