Sign
Purpose 
Returns one of three possible values: -1 when number is negative, 0 when it’s zero, and 1 when it’s 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
Examples 
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