SIGN

Returns the sign of the specified number.

Syntax

SIGN( Number n ) → Number

Parameters

n

Required. The number to test.

Remarks

The function returns -1 if n is negative, +1, if n is positive, and 0 if n is zero.

Example

Formula

=SIGN(10)
=SIGN(A1-B1)

See Also

Function Reference
ABS Function