SIGN (Primitive Spread Function) returns the sign of a number.

SYNTAX:

SIGN(value)

REMARKS:

Returns 1 if the number is positive, 0 if the number is 0, and –1 if the number is negative. 

EXAMPLES:

SIGN(B3)
SIGN(-5)=-1