test - any numeric value or logical
expression
result2 - expression or field name
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.
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.