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

Use the SIGN function to determine the sign of a number (whether it's positive, negative, or zero).

The function returns 1 if the number is positive, -1 if the number is negative, and 0 if the number is zero.

Syntax

SIGN(number)

The sign function has the following arguments.

Argument Data type Description
number (required)

Number

The number you want to determine the sign of.

Constraints

This function has no constraints.

Examples

The following table shows some example formulas using the SIGN function.

You can enter values directly into your formula, or reference line items or list properties.

Formula Description Result
SIGN(Product.Sales)

This example shows how you can include line items or list properties in your formula. In this example, the value of Product.Sales is 50.

1

SIGN(100)

The sign of 100 (a positive number).

1

SIGN(0)

The sign of 0 (zero).

0

SIGN(-10)

The sign of -10 (a negative number).

-1

Excel equivalent

SIGN