1. Calculation functions
  2. All Functions
  3. Numeric functions
  4. SIGN

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)

Arguments

ArgumentData typeDescription
NumberNumberThe number to determine the sign of.

The SIGN function returns a number.

Excel equivalent

SIGN

Examples

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