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:

• Use row or column formulas as opposed to cell formulas whenever possible.

• Use reference properties instead of functions when possible.

  Rows, columns, or cell references can have a property associated with them. For example, the row reference: [1:5].sum produces the same result as using the Sum function; Sum([1:5]). However, the first formula executes faster since it is being used as a reference property.

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

• Use parentheses only when necessary.

  Improper use of parentheses can result in unnecessary evaluation iterations within the evaluation routine of the calculation engine.

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, select the column or row.

   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. Select a function from the drop-down list, and then enter the formula in the formula text box to the right of the drop down.

   See Using Functions.

3. Click to validate the formula.