About formulas
Formulas perform specific operations on one or more values in a database file, and return a single result.
Formulas can be used to define:
 •
 •
 •
 •
 •
calculations in some FileMaker script steps, such as the script steps If, Exit Loop If, Set Field, Insert Calculated Result, and Replace Field Contents. See Creating scripts to automate tasks.
 •
Formulas can contain:
 •
constants - numbers, text, date, or time values that don’t change.
 •
operators - symbols that indicate how to combine or compare two or more values.
 •
functions - predefined, named formulas that perform specific calculations and return single, specific values for each repetition.
 •
field references - fields in the same table or in a related table. A related field referenced in a calculation has the syntax tablename::related field. See Working with related tables and files.
Formula examples
 •
FirstName & “ ” & LastName returns the first and last name separated by a space. For example, Michelle Cannon.
 •
SubTotal * .08 returns the value in the SubTotal field multiplied by .08.
Related topics 
About functions
Functions reference (category list)
Functions reference (alphabetical list)
Using operators in formulas
Identifying text constants and special characters in formulas
Adding a new line to the results of a formula
Adding comments to a formula
Using a reserved word or symbol for a field or table name