2. Calculation functions
  3. All functions
  4. Numeric functions
  5. 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

Disclaimer

We may update our documentation occasionally, but will only do so in a way that does not negatively affect the features and functionality of the Anaplan service.