The SIGN function returns the sign of a number (whether it's positive, negative, or zero). The SIGN function returns 1 for positive numbers, 0 for zero, and -1 for negative numbers.

SIGN(Number)

ArgumentData typeDescription
NumberNumberThe number to determine the sign of.

The SIGN function returns a number.

SIGN

FormulaResult
SIGN(100)1
SIGN(0)0
SIGN(-10)-1