Navigation:  Formulas and functions > Functions from A to Z > SIGN (sign of a number)

Syntax:

SIGN(Number)

Description:

This function returns the sign of a Number. The following values may be returned:

1 if Number is positive

-1 if Number is negative

0 if Number is zero

Example:

SIGN(-5) returns -1

See also:

ABS, NEG