Skip to main content
insightsoftware Documentation insightsoftware Documentation
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

CF_RELATIVE

The CF_RELATIVE function can be used in a template to return a cell value with relative row and column references.

Enter the formula =CF_RELATIVE(<number of rows>,<number of columns>)

The following parameters need to be defined:

  • Number of rows (up or down) the value should be fetched. Define the value with a minus if it should be in a row above.
  • Number of columns (left or right) the value should be fetched. Define the value with minus if it should be in a column to the left.

Example

=CF_RELATIVE(1,2) will return the cell 1 row down and two columns to the right.

=CF_RELATIVE(-1,0) will return the cell 1 row above.

Note: The separator in the formula depends on the culture you are using in the application. "," for en-US, ";" for sv-SE, and so on.

Published:

CF_RELATIVE

The CF_RELATIVE function can be used in a template to return a cell value with relative row and column references.

Enter the formula =CF_RELATIVE(<number of rows>,<number of columns>)

The following parameters need to be defined:

  • Number of rows (up or down) the value should be fetched. Define the value with a minus if it should be in a row above.
  • Number of columns (left or right) the value should be fetched. Define the value with minus if it should be in a column to the left.

Example

=CF_RELATIVE(1,2) will return the cell 1 row down and two columns to the right.

=CF_RELATIVE(-1,0) will return the cell 1 row above.

Note: The separator in the formula depends on the culture you are using in the application. "," for en-US, ";" for sv-SE, and so on.

For an optimal Community experience, Please view on Desktop
Powered by Zendesk