Sgn returns an integer indicating the sign of a number. The required parameter, number, is any valid numeric expression. If number is less than zero -1 is returned, if number is greater than zero 1 is returned, if number is equal to zero, 0 is returned.
Rem Sgn Example 'Sgn returns the sign of a number as -1 or 1 Dim Pos, Neg, Zero Pos = Sgn(44) Neg = Sgn(-17) Zero = Sgn(100 - 100) Print "Positive:", Pos Print "Negative:", Neg Print "Zero:", Zero
Positive: 1 Negative: -1 Zero: 0