Formula Table window

Use this window to set up a formula table by entering the conditional criteria, expected responses, and values you want returned to the formula.

You can set up a formula table with one or two conditions:

  • One dimensional sets up a formula table with a single input condition. During takeoff, the formula table returns a value based on the entry for that variable or formula. Example
  • Two dimensional sets up a formula table with two input conditions. During takeoff, the formula table returns a value based on the entries for two variables or formulas. Example

Open the Formula Table window in one of the following ways:

  • On the ribbon, from the Calculations group on the Data tab, click Formula Tables.
  • In classic view, click Database menu > FormulasFormula Tables.