Use the Formula Bar

How to Show the Formula Bar

To show the formula bar, select  More  Formula Bar in the Tools section of the story page toolbar.

How to Display Formulas in the Formula Bar

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.

How to Add Formulas

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. Press ENTER (on Windows) or RETURN (on Mac) to confirm your entry.

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.

How to View All Formulas

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

Related Information

You can add calculated rows and columns to your table, or create calculations and formulas within the table. For more information about adding formulas in table rows and columns, see Create Client Calculations in Table Cells.

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.