SIGN¶

Returns the sign of given number.

Syntax

=SIGN(Value)

Arguments

Name Description
Value Value to check.

Return Value

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

Example

Function Result
=SIGN(-3) -1