SIGN

Determines the sign of a number

SIGN( number)

Returns the sign of a number

Arguments

Argument

Description

number

Number(s) to find sign of

Output

Returns -1 for a negative number, 0 for 0, and 1 for a postive number

Example

SIGN(-2.5) = -1
SIGN(2.5) = 1

Last updated