Returns an integer indicating the sign of a number.
Sgn(number) |
Arguments
The number argument can be any valid numeric expression.
Return Value
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:
Copy Code | |
---|---|
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. |