Help

FILEMAKER PRO HELP 1283
Related topics
About formulas
Comparison operators
Comparison operators compare two values and return either True or False. (Such expressions are
sometimes called Boolean expressions.) Mathematically, a result of True equals 1 and False equals
0.
Note You can also use <> for Not Equal To (≠), >= for Greater Than or Equal To (≥), and <= for Less
Than or Equal To (≤).
Related topics
About formulas
Logical operators
Logical operators can build compound conditions into a formula, such as two or more conditions that
must be met before you choose a particular method of calculation. With logical operators, you can
describe such combinations of conditions.
Use AND, OR, or XOR with two expressions; use NOT with one expression.
- Minus Subtracts the second value from the first
* Multiply Multiplies each value
/ Divide Divides the first value by the second
^ Power Of Raises the first value to the power of the second value
( ) Precedence FileMaker Pro evaluates formulas from left to right, performing
multiplication and division before addition and subtraction. Using
parentheses lets you change the order: FileMaker
Pro evaluates
expressions between parentheses first. For more information on the order
in which operators are evaluated, see Using operators in formulas.
Symbol Name Definition
Symbol Name Definition
= Equals True if the items are equal
≠ Not Equal To True if the items are not equal
> Greater Than True if the value on the left exceeds that
on the right
< Less Than True if the value on the left is less than
the value on the right
≥ Greater Than or Equal To True if the value on the left is greater
than or equal to the value on the right
≤ Less Than or Equal To True if the value on the left is less than or
equal to the value on the right