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)

Argument	Type	Description
value	Number	The value to calculate sign

=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

Updated 9 months ago