Description
Determines the sign of a Number. Returns 1 if the number if positive, 0 if the number is 0, -1 if the number is negative.
Syntax
SIGN(Number)
Arguments
| Argument | Type | Dimensions | Description |
|---|---|---|---|
| Number (required) | Number | Any Dimensions | Number to get the sign from. |
Returns
| Type | Dimensions |
|---|---|
| Number | Dimensions of argument Number |
Examples
| Formula | Result | Description |
|---|---|---|
SIGN(2.5) | 1 | |
SIGN(0) | 0 | |
|
| -1 |
|
See also
Excel: SIGN
Related articles: ABS
More of a hands-on learner?
Talk to your Customer Success Manager about downloading the Functions and Modifiers in Pigment Application into your workspace. It includes examples of every formula and modifier in Pigment!
