Excel SIGN Function

Using the Excel SIGN Function


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.


=SIGN (number)

Syntax Breakdown

Required. 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.

Excel SIGN VALUE Error