Creating Formulas

When you select a cell, column, or row containing a formula, you can apply a unique formula to that cell. When you create formulas, keep in mind the following points:

  • For optimal performance, use row or column formulas as opposed to cell formulas whenever possible.

  • Avoid using cross-axis references and consider using a cell reference if possible.

To create a formula:

  1. In a grid, insert a formula row or column and select the formula cell.

    To apply a formula to the entire column or row, click the column or row header cell.

    When you use a cell formula in a row or column formula, the cell formula should reference the cells exactly (intersection) and not just the row and column.

    See Defining Formula Rows and Columns.

  2. Do one of the following:
    • Enter a formula manually.

    • Click formula function, select a function from the drop-down list, and enter the formula parameters.

    See Using Functions.

  3. Click validate to validate the formula, or click clear to clear the formula bar and start over.