Sgn Function
Returns a Variant (Integer) indicating the sign of a number.
Syntax
Sgn(number)
The required number argument can be any valid numeric expression.
Return Values
| If number is | Sgn returns |
|---|---|
| Greater than zero | 1 |
| Equal to zero | 0 |
| Less than zero | -1 |
Remarks
The sign of the number argument determines the return value of the Sgn function.
Example
This example uses the Sgn function to determine the sign of a number.
|