Manuals/calci/INDIRECT
Jump to navigation
Jump to search
INDIRECT(ReferenceText, ReferenceStyle)
- where, represents reference to a cell as a text string
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle ReferenceStyle} is a logical value that specifies the type of reference in ReferenceText
represents reference to a cell as a text stringINDIRECT() displays the value referenced indirectly by a text string.
Description
INDIRECT(ReferenceText, ReferenceStyle)
- INDIRECTION is the ability to reference something using a name, reference, or container instead of value itself.
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle ReferenceText} can be a reference to a cell as text string, A1 style reference, and R1C1 style reference or a name defined as a reference.
- If *Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle ReferenceText} is invalid, Calci displays an error message.
- If Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle ReferenceText} refers to a cell outside the column limit, Calci displays and error message.
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle ReferenceStyle} can be a logical value TRUE or FALSE. If omitted, Calci assumes it to be TRUE.
- If Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle ReferenceStyle} is TRUE, Calci interprets Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle ReferenceText} as A1-style reference.
- If Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle ReferenceStyle} is FALSE, Calci interprets Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle ReferenceText} as R1C1-style reference.
Examples
Consider the following table with Columns A as data point and Column B as array input for MOVINGAVERAGE() function.
| Reference Data | Data | |
| B2 | 5667 | |
| B3 | SMITH | |
| ZCUBES | Calci | |
| 5 | 60 | |
=INDIRECT($A$2) : Reads the reference value in A2 that points to B2. Displays the data value in cell B2 5667 as output.
=INDIRECT($A$3,TRUE) : Reads the reference value in A3 that points to B3. Displays the data value in cell B3 SMITH as output.
=INDIRECT($A$4, TRUE) : Displays empty cell referring to B4.
=INDIRECT("B"&A5, FALSE) : Displays 60