U.M. (Mac OS)

Creating a database file 2-17
Mathematical operators
Use the following mathematical operators with numeric expressions.
Comparison operators
Comparison operators compare two expressions and return either true
or false (sometimes called a Boolean expression). Arithmetically, a
result of true equals 1 and a result of false equals 0.
Symbol Name 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 (A
2
+ B
2
)
Radius^3 returns (Radius
3
)
Choose FileMaker Help Index from the or Help menu, and then type:
E mathematical operators
Symbol Name Definition Examples
= Equal to True when both items
are equal
38=39 returns false
38=38 returns true
≠ or <> 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