U.M. (Mac OS)

2-18 FileMaker Pro User’s Guide
Logical operators
When you want FileMaker Pro to perform a calculation based on two or
more conditions, use logical operators to describe such conditions.
≥ or >= Greater than or
equal to
True when the value on
the left is greater than or
equal to the value on the
right
5≥6 returns false
5≥5 returns true
≤ or <= Less than or
equal to
True when the value on
the left is less than or
equal to the value on the
right
5≤6 returns true
19≤18 returns false
Choose FileMaker Help Index from the or Help menu, and then type:
E comparison operators
Operator Definition Example
AND True only when both of two values are
true. The result is:
1 true when true AND true
1 false when false AND true
1 false when false AND false
InvoiceTotal<100 AND
SalesTax<6
OR True when either of two values is true. The
result is:
1 true when true OR true
1 true when true OR false
1 false when false OR false
InvoiceTotal<100 OR
SalesTax<6
XOR True when either, but not both, of two
values is true. The result is:
1 false when true AND true
1 true when false AND true
1 false when false AND false
InvoiceTotal<100 XOR
SalesTax<6
NOT Changes a value within parentheses from
false to true or from true to false. The
result is:
1 false when NOT(true)
1 true when NOT(false)
NOT InvoiceTotal>1000
Symbol Name Definition Examples
?