Reference > Functions reference > Number functions > Sign
 
Sign
Purpose 
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
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