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

Comment

=SIGN(-3)

-1