Sgn Function

Returns a Variant (Integer) indicating the sign of a number.

Syntax

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

Remarks

The sign of the num argument determines the return value of the Sgn function.

Example

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