Sgn

Returns the sign of a number, positive or negative.

Syntax
      Sgn(Number)

Key
   Number  The number to return the sign of.

If number > 0, then Sgn() will return 1.
If number = 0, then Sgn() will return 0.
If number < 0, then Sgn() will return -1.

The Sgn() function can be used in VBA or in an SQL query.

Example

Dim intDemo as Integer
intDemo = Sgn(64)
MsgBox intDemo

“One of the main causes of the fall of the Roman Empire was that, lacking zero, they had no way to indicate successful termination of their C programs” ~ Robert Firt

Related:

Abs - The absolute value of a number (ignore negative sign).
Int - Return the integer portion of a number.
Excel has an equivalent function sign()