• 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

RCR Function

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

Syntax

RCR(integer,integer)

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

Example 1

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.

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.

Example 3

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

• Mathematical and Financial Functions