You are here: All Help Topics > Other Information > Cell Functions > RCR function

RCR Function

The RCR function returns the value of a cell in a table relative by column and row to the current cell.

RCR(integer,integer)

The first integer is the column position and the second integer is the row position relative to the current cell.

Entering RCR(2,-1) in table cell A.A3 returns the value in cell A.C2, the cell two columns to the right and one row up.

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

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

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

Entering RCR(2#,-1#) in table cell A.A3 returns the value in cell A.C2, the cell two columns to the right and one row up. If any columns or 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 column was inserted between column A and column B, and a row inserted between row 2 and 3, the formula would update to read RCR(3#,-2#).

Related Topics