Article updated on February 15, 2018

The SIGN function returns the sign of a number. 1 for a positiv number, 0 (zero) for a 0 (zero) and -1 for a negative number.

Formula in cell C3:


Excel Function Syntax



number Required. A number for which you want to know the sign of.