Sgn (function)

Syntax

Sgn(number)

Description

Returns an Integer indicating whether a number is less than, greater than, or equal to 0.

Comments

Returns 1 if number is greater than 0.

Returns 0 if number is equal to 0.

Returns –1 if number is less than 0.

The number parameter is a numeric expression of any type. If number is Null, then a runtime error is generated. Empty is treated as 0.

Example

This example tests the product of two numbers and displays a message based on the sign of the result.

Sub Main()
  a% = -100
  b% = 100
  c% = a% * b%
  Select Case Sgn(c%)
    Case -1
      MsgBox "The product is negative " & Sgn(c%)
    Case 0
      MsgBox "The product is 0 " & Sgn(c%)
    Case 1
      MsgBox "The product is positive " & Sgn(c%)
    End Select
End Sub

See Also

Abs (function).

More information

S