Working with standard databases > Building and modifying a standard database > Formulas > Creating a formula table

Learn more

Creating a formula table

Before you begin

You should understand what a formula table is and why you would want to create one before completing this procedure. Example

To create a formula table:

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 > Formulas > Formula Tables.
Click [Add].
From the Variable/Formula List, choose a variable or formula for the table's row selector. Use the Variables and Formulas option buttons to switch the list between variables and formulas.
Complete the fields at the top of the window.

Tip: You can use [Copy] and [Prefill] for this purpose.

For more information, click $image\windhlp.gif$ on the title bar of the window, and then click a field or button.
Fill in the formula table. How?
Enter the input ranges for the row selector.
Two dimensional table only: Enter the input ranges for the column selector.
Enter the return values in the table cells.
When you finish setting up the formula table, click [OK] to save it.
Set up additional formula tables in the same manner. When you finish, click [Close].

Tips:

You can resize the Formula Table window by pointing to one of its corners or borders and then dragging the corner or border until the window is the size you want.
You can also create formula tables directly from the Formula window. How?