SIGN

The SIGN function returns the sign of a number: 1 if positive, 0 if zero, or -1 if negative.

Syntax

=SIGN(number)

Parameters

• number: The number for which you want to determine the sign

Examples

=SIGN(10) // Returns 1
=SIGN(-5) // Returns -1
=SIGN(0) // Returns 0