Returns a Variant (Integer) indicating the sign of a number.
Sgn([num]) |
The optional num argument is a Double or any valid numeric expression. If this argument is omitted, is a non-initialized variable, or Null, the function returns 0.
Return Values
If num is | Sgn() returns |
Greater than zero | 1 |
Equal to zero | 0 |
Less than zero | -1 |
The sign of the num argument determines the return value of the Sgn
function.
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. |
See Also |
Abs Function |