The Formula Bar

Use the formula bar to calculate values in empty table rows and columns, or cells outside a table.

To show the formula bar, select from the toolbar in the Story page.

Choose a cell that has a formula applied to it, such as the header of a calculated row or column in a table, or a cell in a grid outside a table. The formula is displayed by default. Choose the icon in the formula bar ( or ) to toggle between displaying the formula and the text value.

You can add a formula to an empty cell in a grid, or to an empty row or column in a table. For more information about adding formulas in table rows and columns, see Create Custom Calculations Within Your Table.

To add a formula, select an empty column or row header, or an empty cell outside a table, and start typing the formula text, beginning with an equals sign (=). (If the formula is a long one, you may prefer to type it in the formula bar instead.)

You can use references to other cells, including cells that contain model data. To add a reference while typing a formula, type the coordinate of the cell (for example, E6), or select the cell. You can also click and drag to select cell ranges, and click an existing reference in the formula and select a new cell to update the reference. Each cell reference is identified by color in the cell and the formula.

To see all formulas on the page, select   Show Formulas.

You can also create calculations in a table or chart using the Calculation Editor. For more information, see Create Custom Calculations for Your Tables or Create Custom Calculations for Your Charts.

For a list of functions, see All Formulas and Calculations.