Using Formula Tools to Insert Formulas

Formulas are available for a selected cell on a contextual toolbar or ribbon.

You can use the following flyouts on the Table contextual ribbon to insert data types and formulas. You can also use these flyouts with the Edit Table contextual toolbar.
  • Data flyout . Lists the available data types.
  • Formula flyout . Lists the available functions.

To insert formulas using formula tools:

  1. Click inside a table cell to select it.
  2. Do one of the following:
    • On the Table contextual ribbon, click the Formula flyout and select a formula.
    • On the Edit Table contextual toolbar, click the Formula flyout and select the formula.
    • Right-click and click Sum, Average, Count, or Cell.
  3. Specify the cell or range of cells corresponding to the selected formula.
  4. Press Enter to calculate the result.