SIGN

Determines whether a number is positive.

Syntax

SIGN(Value)

Value is a number or a formula that returns a number. The function returns 1 if Value is positive, -1 if Value is negative and 0 if Value is 0.

Example

This example returns -1:

SIGN(-3.4)