• Mathematical and Financial Functions
  • Mathematical and Financial Functions
  • ABS function
  • AVERAGE function
  • CGROUP function
  • CGROUPT function
  • COLCOUNT function
  • COUNTIF function
  • EXP function
  • FV function
  • LOG function
  • 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

RC Function

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

Syntax

RC(integer)

Positive integers tell CaseView to look in columns to the right of the current point.

Negative integers tell CaseView to look in columns to the left of the current point.

Example 1

RC(1)

Entering RC(1) in table cell A.A1 returns the value in table cell A.B1, the cell in the next column.

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 B2 has a skip condition containing the function RC(-1). CaseView will look at the cell to the left, A2, 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.

RC(1#)

Entering RC(1#) in table cell A.A1 returns the value in table cell A.B1, the cell in the next column. If any columns 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, the formula would update to read RC(2#).

Related Topics

• Mathematical and Financial Functions