Defining Formula Rows and Columns

A formula consists of a combination of grid or table references, mathematical functions, and arithmetic operators. A grid or table reference uses values from the current grid/table or another grid/table in a calculation. You can define arithmetic formulas on formula rows, columns, cells, or a range of formula cells in a grid/table. For example, you can build a formula that adds one or more rows. Or, you can multiply two rows, add a third row, then display the result. For an explanation of the mathematical functions you can use in formulas, see Mathematical Functions.

When defining formula rows or columns, formula results are calculated based on the underlying data values in one or more specified cells. If the cells used in a formula are formatted to use scaling, the formula results may differ from the displayed values for the cells, since the underlying, unformatted data values are used in the formula.