SIGN

Name

Sign of a number

Description

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.

See also ABS and NEG.

Data Type

Accepts numeric data. Returns numeric data. For more information, see Data Type for Each Cell Type.

Example

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