SIGN
Determines the sign of a number, the result of a calculation, or a value in a column. The function returns 1 if the number is positive, 0 (zero) if the number is zero, or -1 if the number is negative.
Syntax
SIGN(<number>)
Parameters
| Term | Definition |
|---|---|
| number | Any real number, a column that contains numbers, or an expression that evaluates to a number. |
Return value
A whole number. The possible Return values are 1, 0, and -1.
| Return value | Description |
|---|---|
| 1 | The number is positive |
| 0 | The number is zero |
| -1 | The number is negative |
Example
The following formula returns the sign of the result of the expression that calculates sale price minus cost.
= SIGN( ([Sale Price] - [Cost]) )
Related content
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for