Formulas and Functions
ഈ കൺട്രോളിൽ മാറ്റം വരുത്തുന്നത് ഈ പേജ് ഒട്ടോമാറ്റിക്കായി അപ്ഡേറ്റ് ചെയ്യാനിടയാക്കും

INDIRECT

The INDIRECT function returns the contents of a cell or range referenced by an address specified as a string value.

INDIRECT(addr-string, addr-style)

addr-string: A string value representing a cell address.

addr-style: An optional modal value specifying the address style.

A1 (TRUE, 1 or omitted): The address format should use letters for columns and numbers for rows.

R1C1 (FALSE): The address should use the R1C1 format, where R1 is the row number of a cell and C1 is the column number.

Notes

  • The given address can be a range reference, such as "A1:C5", not just a reference to a single cell. If used this way, INDIRECT returns an array that can be used as an argument to another function. For example:

    =SUM(INDIRECT("A1:C5", 1)) returns the sum of the values in the cells referenced by the addresses in cells A1 to C5.

  • You can use the explicit intersection operator to force a formula to return a single value instead of a spilled array.

Example

If cell A1 contains 99 and A20 contains A1:

=INDIRECT(“A20”) returns 99, the contents of cell A1.

See alsoINDEX
Morty Proxy This is a proxified and sanitized view of the page, visit original site.
സഹായകമായോ?
കാരക്റ്റർ പരിധി: 250
പരമാവധി കാരക്റ്റർ പരിധി 250 ആണ്.
നിങ്ങളുടെ ഫീഡ്ബാക്കിന് നന്ദി.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.