These docs are for v1.0. Click to read the latest docs for v1.2.

SIGN

Calculates the sign of the specified number as -1, 0, or 1, depending on whether the specified number is negative, zero, or positive, respectively

Syntax

=SIGN(value)

Arguments

ArgumentTypeDescription
valueNumberThe value to calculate sign

Examples

=SIGN(3.1459)1
Calculates the sign of the value 3.14159

=SIGN(-2)-1
Calculates the sign of the value -2

=SIGN(0)0
Calculates the sign of the value 0