Home  >  Article  >  How to use indirect function?

How to use indirect function?

烟雨青岚
烟雨青岚Original
2020-07-03 16:36:225663browse

The indirect function is used to return a reference specified by a text string. The syntax is: "INDIRECT(ref_text,[a1])"; "Ref_text" is a reference to the cell; "a1" is a logical value indicating the type of reference contained in the cell "ref_text".

How to use indirect function?

The indirect function is used to return the reference specified by a text string

The syntax is:

INDIRECT(ref_text,[a1])

Ref_text is a reference to the cell. This cell can contain A1-style references, R1C1-style of a reference, a name defined as a reference, or a reference to a text string cell. If ref_text is not a valid cell reference, the INDIRECT function returns the error value #REF! or #NAME?.

If ref_text is a reference to another workbook (external reference), the workbook must be opened. If the source workbook is not open, the INDIRECT function returns the #REF! error value.

a1 is a logical value indicating the type of reference contained in cell ref_text.

If a1 is TRUE or omitted, ref_text is interpreted as an A1-style reference.

If a1 is FALSE, ref_text is interpreted as an R1C1-style reference.

For more related knowledge, please visit PHP Chinese website! !

The above is the detailed content of How to use indirect function?. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn