Learn more
Changing an existing formula table
Changing the conditions for a formula table
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 Data tab, click . group on the
- In classic view, click Database menu > Formulas > Formula Tables.