Sgn

Returns an integer indicating the sign of a number.

Structure

Sgn(number)

Parameters

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

Description

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

Example

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. |