Article updated on May 04, 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:

=SIGN(B3)

Excel Function Syntax

SIGN(number)

Arguments

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