Link Search Menu Expand Document

SIGN

Returns the sign of a number according to the table below.

Syntax 

SIGN(<expr>)

<expr> can be any expression that evaluates to a numeric data type.

If Returns
<expr> < 0 -1
<expr> = 0 0
<expr> > 0 1

Examples 

SIGN(5)

Returns: 1

SIGN(-1.35E-10)

Returns: -1

SIGN(0)

Returns: -1