Skip to main content
Version: Streamsheets 3.0

SIGN

Returns the sign of given number.

Syntax

=SIGN(Value)

Arguments

NameTypeDescription
ValueNumberValue to check.

Return

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

Examples

FormulaResultComment
=SIGN(-3)
-1