SIGN

Returns the sign of given number.

Syntax

=SIGN(Value)

Arguments

Name	Description
Value	Value to check.

Return

Returns 1, if number value is positive, -1, if it is negative or 0, if value is 0.

Examples

Formula	Result	Comment
=SIGN(-3)	-1