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.

For more information, click the Help icon available on the ribbon on the title bar of the window, and then click a field or button.