User manual

Using formulas and functions 11-3
Operators
You combine expressions using operators, symbols that determine
which operation to perform on the expressions. You place operators
between the expressions you want to perform the operation on.
Each operator has a precedence, which determines the order in which
calculations are performed in a formula containing more than one
operator. FileMaker Pro evaluates operators from left to right and
performs multiplication and division before addition and subtraction.
You can change the precedence by enclosing the expression you
want calculated first in parentheses.
Mathematical operators
Use the following mathematical operators with numeric expressions.
Comparison operators
Comparison operators compare two expressions and return either
true or false. (True and False are Boolean results.) Arithmetically, a
result of true equals 1 and a result of false equals 0.
This expression Returns
2+3*2 8
(2+3)*2 10
Operator Definition Examples
+
(Addition)
Adds two values 2+2
Subtotal+Sales Tax
–
(Subtraction or
Negation)
Subtracts the second
value from the first, or
changes the sign to + or –
2–2
InvoiceTotal–Discount
–2
*
(Multiplication)
Multiplies each value Subtotal*Sales Tax
DaysLate*.01*
LeasePayment
/
(Division)
Divides the first value by
the second
Kilometers Driven/Liters
Inches/12
^
(Power of, or
Exponentiation)
Raises the first value to
the power of the second
value
A^2+B^2 returns (A2 + B2)
Radius^3 returns (Radius3)
Operator Definition Examples
=
(Equal to)
True when both items are
equal
38=39 returns false
38=38 returns true
<>
or ≠ (Mac OS)
(Not equal to)
True when the items are not
equal
38<>39 returns true
38<>38 returns false
>
(Greater than)
True when the value on the
left exceeds the value on
the right
5>6 returns false
19>1 returns true
<
(Less than)
True when the value on the
left is less than the value on
the right
5<6 returns true
19<1 returns false
>=
or ≥ (Mac OS)
(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 ≤ (Mac OS)
(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