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 |