Syntax
Sgn(n)
Remarks
Determines whether n is positive, negative, or 0 (zero).
Value | Explanation |
0 (zero) | If n is 0 (zero) |
–1 | If n is a negative number |
1 | If n is a positive number |
Example
This example compares two values. If the difference is negative, a message box is displayed.
maySales = 1200
juneSales = 1000
difference = juneSales - maySales
If Sgn(difference) = -1 Then
MsgBox "Sales fell by" + Str$(Abs(difference)) + " dollars!"
End If
See Also
Abs(), Int(), Rnd()