Filemaker Pro 8.5 Educational Maintenance T3 TJ083LL/A User Manual

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 

 (True, 

False) result. 

•

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 

 checkbox.

If(Country = “USA”;“US Tech Support”;“International Tech Support”) 

returns 

, if the Country field contains France or Japan. 

Returns 

 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 

. 

IsEmpty(field)

field - any 

, or numeric expression

number

Returns True(1) if field is empty, if a 

, 

, or file is 

missing, or if some other error occurs; otherwise returns False(0).

IsEmpty(OrderNum) returns 

 if the OrderNum field is empty.

If(IsEmpty(LastName);“Invalid record”;““) displays 

 if the 

LastName field is blank, but displays nothing if there is an entry in LastName.

IsEmpty(Payments::DatePaid) returns 

 if, for example, the Payments table has 

been moved or renamed.

IsEmpty(“text”) returns 

.