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