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
Was this topic helpful?
Send feedback.