Learn more

Testing a formula table

Inserting a variable in a formula

Adding a formula "on the fly"

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:

  1. 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.

  2. Click [Add].

  3. In the Variable / Formula List window that opens:

    1. For the List Type, select Formulas.

    2. Select a formula for the table's row selector.

      If you need a formula that does not yet exist, you can add it "on the fly."

    3. Click [OK].

      You are returned to the Adding Database Formula Table window.

  4. Complete the fields at the top of the window.

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

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

  5. Fill in the formula table. (For more information, see Tips for filling in the formula table.)

  6. Enter the input ranges for the row selector.

    For two dimensional table only, enter the input ranges for the column selector.

  7. Enter the return values in the table cells.

  8. When you finish setting up the formula table, click [OK] to save it.

  9. 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.

  • Create formula tables directly from the Formula window.

    1. With the cursor in the formula text box, click the right mouse button.
    2. Select Create Formula Table from the shortcut menu.