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: