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: