SIGN function

Prev Next

​​​Description

Determines the sign of a Number. Returns 1 if the number if positive, 0 if the number is 0, -1 if the number is negative.

Syntax

SIGN(Number)

Arguments

Argument

Type

Dimensions

Description

Number

(required)

Number

Any Dimensions

Number to get the sign from.

Returns

Type

Dimensions

Number

Dimensions of argument Number

Examples

Formula

Result

Description

SIGN(2.5)

1

SIGN(0)

0

SIGN(-2.5)

-1

See also

Excel: SIGN

Related articles: ABS

More of a hands-on learner?

Talk to your Customer Success Manager about downloading the Functions and Modifiers in Pigment Application into your workspace.  It includes examples of every formula and modifier in Pigment!