Functions Reference

Chapter 8
|
Logical functions 129
If
Format
If(test;result1;result2)
Parameters
test - any numeric value or logical expression
result1 - expression or field name
result2 - expression or field name
Data type returned
text, number, date, time, timestamp, container
Description
Returns one of two possible results depending on the value of test. If test is True (any
non-zero numeric result), FileMaker Pro returns result1. If test is False (0), result2
is returned. Test must be an expression that returns either a numeric or Boolean (True,
False) result.
Notes
• If you have more than two possible results, consider using the Case function.
• By default, if test refers to a field that doesn’t yet contain a value, the If function
returns an empty result. To override this functionality, deselect the Do not evaluate if
all referenced fields are empty checkbox.
Examples
If(Country = “USA”;“US Tech Support”;“International Tech Support”)
returns International Tech Support, if the Country field contains France or Japan.
Returns US Tech Support if the Country field contains USA.
If(State =”CA”;Subtotal * CA Tax Rate;0) returns the tax if the purchaser is
a resident of California, otherwise returns 0.
IsEmpty
Format
IsEmpty(field)
Parameter
field - any field name, text expression, or numeric expression