Formulas

You define formulas to specify the mathematical functions that the system applies to columns, rows, or cells. Refer to columns, rows, and cells using these conventions:

• Enter sections as Sxxx, where xxx is the section number.

• Enter columns as Cxx, where xx is the column number.

• Enter rows as Rxxxx, where xxxx is the row number.

• Reference cells using both the column and row number.

  For example, enter R0020C01 to refer to the cell at the intersection of row 20 and column 01 for the current section. Enter S003R0020C01 to refer to the intersection of row 20 and column 01 for the third section.

  Note: If you do not define the section, row, or cell, the system uses the current position.

• Use standard arithmetic symbols.

  For example, use + for addition, - for subtraction, * for multiplication, and / for division.

• Enclose the section, column, or row reference in brackets.

  For example, write a formula for adding the amounts in columns 01 and 02 as [C01]+[C02].