Excel SIGN Function

Using the Excel SIGN Function

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

Number
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