Help

Creating a database
F
ILEMAKER PRO HELP 206
Using operators in formulas
An operator is a symbol or instruction that manipulates expressions in a formula. For example, the
plus (+) operator tells FileMaker Pro to add one expression to another. FileMaker Pro has four types
of operators:
• Mathematical operators
• Comparison operators
• Logical operators
• Text operators
Note For information on using variables in formulas, see Using variables.
Order of evaluation
Operators are evaluated in the order they are listed below.
1. /* */, //
2. " ", \, ¶, ${ }
3. (, )
4. NOT
5. ^
6. *, /
7. +, -
8. &
9. =, ≠, >, <, ≥, ≤
10. AND
11. OR, XOR
Related topics
About formulas
Identifying text constants and special characters in formulas
Use opening and closing quotation marks to indicate the beginning and end of text constants.
Quotation marks without text between them indicate an empty value (no text).
Use backslashes to preserve special operator characters, such as double quotation marks or a
carriage return character, simply as characters within a string (instead of as operators).
Example
"\"Fred " & "and Jane\"" returns “Fred and Jane”.
Related topics
About formulas
Defining calculation fields
Text operators
Using operators in formulas
Functions reference (category list)