INDIRECT

Home

4D v18

INDIRECT


INDIRECT ( cell \| cellRange )

Parameter	Typ	Beschreibung
cell \| cellRange	CellRef	Reference to a cell, a name defined as a reference, or a text string reference to a cell or to a range

Beschreibung

The INDIRECT function returns the contents of cell. The cell parameter (mandatory) can be any cell reference, including absolute reference such as $A$1 or a character string. Use INDIRECT when you want to change the reference to a cell within a formula without changing the formula itself.

The INDIRECT function can also return the internal reference of a range of cells (reference cannot be displayed but can be used by other 4D View Pro functions).

Beispiel

INDIRECT("A1") //returns the contents of cell A1

COLUMN(INDIRECT("A1:A3")) //column 1
ROW(INDIRECT("A1:F1")) //row 1

Siehe auch