![]() |
Next Page |
| Contents > Creating a database > Working with formulas and functions > Using operators in formulas |
|
|
| 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: =, ≠, >, < , ≥, ≤ |
|
|
You can also use <> for Not Equal To (≠), >= for Greater Than or Equal To (≥), and <= for Less Than or Equal To (≤). |
| Logical operators: AND, OR, NOT, XOR |
| Text operators: &, " ", \, ¶, /* */, //, ${ } |
| Note For information on using variables in formulas, see Using variables. |
| Related topic |
| About formulas |
|
|
| Contents > Creating a database > Working with formulas and functions > Using operators in formulas | Next Page |