Using Conditions and Formulas

The expressions for conditions and formulas use the same syntax and support the same range of operators and functions. The only difference is that the expression for a condition must always evaluate to TRUE or FALSE. That is, it must result in a Boolean (Yes/No) data type. The expression for a formula must result in the data type of the field to which it is assigned.

Both Formulas and Conditions are created using the Formula Editing Menu.