Reference > Functions reference > Number functions > Sign
 

Sign

Returns -1 when a number is negative, 0 when zero, 1 when positive.

Format 

Sign ( number )

Parameters 

number - any numeric expression or field containing a numeric expression

Data type returned 

number

Originated in 

FileMaker Pro 6.0 or earlier

Example 1 

Sign(15.12) returns 1.

Sign(-175) returns -1.

Sign(BalanceDue) returns 0, if BalanceDue is a number field containing 0.

Related topics 

Functions reference (category list)

Functions reference (alphabetical list)

About formulas

About functions

Defining calculation fields

Using operators in formulas