Bemærk
Adgang til denne side kræver godkendelse. Du kan prøve at logge på eller ændre mapper.
Adgang til denne side kræver godkendelse. Du kan prøve at ændre mapper.
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]) )