Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Returns an integer indicating the sign of a number.
Syntax
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:
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.