Kommentar
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
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]) )