Learn more

Changing an existing formula table

Changing the conditions for a formula table

Changing the return values for a formula table

About formula tables

Creating a formula table

Tips for filling in the formula table

Formula Table window

Formula Tables command

Use this command on the Data tab to create, edit, and test the individual formula tables in the standard database. A window opens so you can set up the conditional criteria for returning the correct value to a formula. Formula Tables is available only when a standard database is open. 

Tips:  

  • Edit Formula Table is available on a button or on the shortcut menu when you are working with formula tables in other windows.

    • Shortcut menus provide access to commands that you may need to accomplish a particular task.

    To open a shortcut menu, point to something in a Sage Estimating (SQL) window, and then right-click it. The available commands vary based on where you are pointing.

  • Use the Options command if you want the Formula Table window to remain in add mode after you save each new record.