Filemaker Pro 10 TU687LL/A Manual De Usuario

50     FileMaker Pro Tutorial

8. Scroll through the list of functions in the upper-right corner of the Specify Calculation dialog box until 

you locate If  (test  ; resultOne ; resultTwo). Double-click this function so that it appears in the large text 
box below.

This function 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, resultOne, and resultTwo with the 
actual components of the calculation.

9. Select the placeholder text test and type the following exactly as it appears here:

Membership Type = “Continuing”

10. Select the placeholder text resultOne, and type 100.

11. Select the placeholder text resultTwo, and type 200.

12. Make sure the calculation result is set to Number. 

13. Click OK.

If you receive an error message, make sure that all spaces and punctuation are identical to the formula 
shown above.

14. Click OK to close the Manage Database dialog box. 

The Renewal Fee field appears at the bottom of the layout, below the Membership info tab panel. 
Depending on the size of your screen, you may need to scroll down to see it.

15. Select the Renewal Fee field and its label and drag them under the Member Since field.

Field list

Verify the type of data to be 
returned by the calculation 

Function list

Replace these 

placeholders 

with your 

calculation

The completed 

calculation