This function gets the sign of a number.
If the specified number is positive, the Sign function will return 1.
If the specified number is negative, the Sign function will return -1.
If the specified number is zero, the Sign function will return 0.
Sign([Number])
Where:
Number is a number or a reference to a number, that you want to determine the sign of.
Rule | Meaning |
|---|---|
| Sign(FundsAvailableTextBoxReturn) | Determines the sign of the return value from the FundsAvailableTextBox, if the value is positive, 1 is returned. If the value is negative, -1 is returned. If the value is zero, 0 is returned. |
FundsAvailableTextBoxReturn Value | Result of the Sign function |
|---|---|
| 1500 | 1 |
| 0 | 0 |
| -12 | -1 |