• Mathematical and Financial Functions
  • ABS Function
  • AVERAGE Function
  • CGROUP Function
  • CGROUPT Function
  • COLCOUNT Function
  • COUNTIF function
  • EXP Function
  • FV Function
  • LOG Function
  • Mathematical and Financial Functions
  • MAX Function
  • MEDIAN Function
  • MIN Function
  • MKDEC Function
  • MKINT Function
  • MOD Function
  • POS Function
  • PV Function
  • R Function
  • RATIO Function
  • RC Function
  • RCNV Function
  • RCR Function
  • RCTOTAL Function
  • ROUND Function
  • ROWCOUNT Function
  • RR Function
  • RRTOTAL Function
  • STDDEV Function
  • SUM Function
  • TOTAL Function

RR Function

The RR function returns the value of a cell in a table relative by row to the current cell. This function is useful for referencing cells in a table where the total number of rows may change. If a row is inserted, the RR function will adjust accordingly to preserve the linkage.

Syntax

RR(integer)

Positive integers tell CaseView to look in rows below the current point.

It follows that negative integers tell CaseView to look in rows above the current point.

Example

RR(2)

Entering RR(2) in table cell A.A1 returns the value in table cell A.A3, the cell two rows below.

Note: This function can also be used in Skip and Hide conditions for paragraphs within a table as shown in Example 2.

Example 2

A paragraph in table cell B3 has a skip condition containing the function RR(-1). CaseView will look at cell B2, to get the value for the skip condition and skip the paragraph accordingly.

Example 3

The function also accepts an additional parameter that allows it to re-reference automatically.

RR(2#)

Entering RR(2#) in table cell A.A1 returns the value in table cell A.A3, the cell two rows below. If any rows are inserted or deleted between the cell containing the formula and the source cell, or if either cell is renumbered, the formula automatically renumbers to reference the original cell. For example, if a row were inserted between row 1 and row 3, the formula would update to read RR(3#).

Related Topics

• Mathematical and Financial Functions