Cells

You can modify cells in rows to override the column or row calculations for a particular cell. You can modify cells in any row except when the row is defined as a title row (row type = TIT). Rows defined as a single account or an account group row (row type = GAC or SAC) enable you to apply a function to the cell when the column that includes the cell is defined as a function column. Rows that are defined as a formula row (row type = FOR) enable you to apply a formula to the cell when the column is defined as a function or a formula column.

This table shows the cell overrides:

Row Type

Function Column

Formula Column

Single Account or Group Account

Can override column function with a cell function

Cannot override column formula

Formula

Can override the row formula with a cell formula

Can override both the row and column formulas with a cell formula