This is the legacy 4D documentation web site. Documentations are progressively being moved to developer.4d.com
- 4D View Pro Reference
-
- 4D View Pro Formulas
-
-
Operators and values
-
Cell references
-
Converting 4D View plug-in formulas
-
ABS
-
ACOS
-
AND
-
ASIN
-
ATAN
-
AVERAGE
-
COLUMNLETTER
-
COS
-
COUNTA
-
EXP
-
FALSE
-
FINDCELL
-
FV
-
IF
-
INDIRECT
-
ISBLANK
-
LEN
-
LN
-
LOOKUP
-
MAX
-
MID
-
MIN
-
NOT
-
NOW
-
NPER
-
OR
-
PI
-
PMT
-
PV
-
RAND
-
RATE
-
ROUND
-
ROW
-
RUNTIME_CURRENT_TIME
-
RUNTIME_DATE
-
RUNTIME_STRING
-
RUNTIME_TIME
-
RUNTIME_VIEW_STRING
-
SIN
-
SQRT
-
STDEV.P
-
SUBSTITUTE
-
SUM
-
TAN
-
TEXT
-
TODAY
-
TRUE
-
TYPE
-
VAR.P
-
INDIRECT
| INDIRECT ( cell | cellRange ) | ||||||||
| Parameter | Type | Description | ||||||
| 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 | |||||
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).
INDIRECT("A1") //returns the contents of cell A1COLUMN(INDIRECT("A1:A3")) //column 1
ROW(INDIRECT("A1:F1")) //row 1
Product: 4D
Theme: 4D View Pro Formulas
4D View Pro Reference ( 4D v19)
