Parts of a formula

A formula can contain any or all of the following: fields, constants (numbers, text, dates), operators, and functions.

Fig. Parts of a formula

  1. Fields. The value of a data field stored in the database.

  2. Constants. Numbers, text or date values entered directly into a formula.

  3. Operators. A symbol that specifies the type of calculation to perform.

  4. Functions. Pre-written formulas that take a value, perform an operation, and return a value.