Quick Start

68 Getting Started Guide
This formula has three parts: a test, a result if the test evaluates as
true (result one), and a result if the test evaluates as false (result two).
You will replace the placeholders test, result one, and result two with
the actual components of the calculation.
7. Select the placeholder test and type Membership Type =
“Continuing” exactly as it appears here.
8. Select the placeholder result one, and type 100.
9. Select the placeholder result two, and type 200.
10. Make sure the calculation result is set to Number.
11. Click OK.
If you receive an error message, make sure that all spaces and
punctuation are identical to the formula shown above.
12. Click Done.
The Renewal Fee field appears at the bottom of the layout.
Depending on the size of your screen, you may need to scroll down
to see it.
Your calculation formula is now complete. When data is entered in
the Membership Type field, FileMaker Pro will compare it to the
word we are testing for, “Continuing.” The test is true if it matches
this word, and the calculation will return your first result, 100. If it
doesn’t match, the test is false, and the second result is returned.
Test your calculation
To see if your calculation works, try changing the value in the
Membership Type field to New, and notice the result in the Renewal
Fee field—it should change as the membership type changes.
Field
list
Formula
list
Replace these placeholders
with your calculation
Verify the type of data to be
returned by the calculation
The completed calculation