Using the Excel SIGN Function
SummarySIGN 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.
Required. Number can be any real number. You can also enter equations for this argument.
Usage NotesSIGN 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,∞)
The number argument for SIGN must be a real number. Other entries will result in the function returning the #VALUE! error.