Sgn Function
Returns an integer indicating the sign of a number.
Sgn(number)
The number argument can be any valid numeric expression.
Return Values
The Sgn function has the following 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.
The following example uses the Sgn function to determine the sign of a
number: Dim MyVar1, MyVar2, MyVar3, MySign
MyVar1 = 12: MyVar2 = -2.4: MyVar3 = 0
MySign = Sgn(MyVar1) ' Returns 1.
MySign = Sgn(MyVar2) ' Returns -1.
MySign = Sgn(MyVar3) ' Returns 0.
|