Sgn Function

Description

Returns an integer indicating the sign of a number.

Syntax

Sgn(number)

The number argument can be any valid numeric expression.

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.

See Also

Abs Function.

Example

This example uses the Sgn function to determine the sign of a number.


MyVar1 = 12: MyVar2 = -2.4: MyVar3 = 0= Sgn(MyVar1)            ' Returns 1.= Sgn(MyVar2)            ' Returns -1.= Sgn(MyVar3)            ' Returns 0.