• Calculation
  • Accumulation
  • Action Events
  • Functions
  • Linkage
  • User Defined Data
  • Values
  • About Cell Calculations
  • About Checking Portions of Calculations
  • About Direct Referencing
  • About Relative Referencing
  • Equation bar
  • Apply rounding
  • Apply rounding relations
  • Calculation Editor
  • Calculation operators
  • Entering a Cell Calculation
  • Entering a Text Value into an Alphanumeric Cell
  • Wildcard characters

About Relative Referencing

The value of the current input cell may be replaced with the value of another cell in the document by using the current cell number as a reference point from which to locate a new cell number. Relative referencing is useful when the document contains a prior year column with cell numbers in the c100 range and a current year column in the c1000 range. A relative reference 1000 adds 1000 to the current cell number and then finds the cell with that number and returns the value. This would be useful if numbers were manually plugged and it is now necessary to transfer current year balances to the prior year cells during a roll forward.

Related Topics

• About cell calculations
• About direct referencing