Sgn()

Sgn() - Determines the sign of a number

Description

The Sgn() function is used to determine the sign of a number, i.e. whether it is greater than, equal to, or less than zero.

Sgn(number)

Returns "1" if greater than zero, "0" if equal to zero, or "-1" if less than zero.

Example

MySign = Sgn("-873.2") 'returns -1

MySign = Sgn("14") 'returns 1