In case of R1C1 notation, ADDRESS returns address strings using the exclamation mark '!' as the sheet name separator, and INDIRECT expects the exclamation mark as sheet name separator. If the argument is not given or has a value other than 0, then the A1 notation is used. In both functions, if the argument is inserted with the value 0, then the R1C1 notation is used.
In INDIRECT, the parameter is appended as the second parameter. In ADDRESS, the parameter is inserted as the fourth parameter, shifting the optional sheet name parameter to the fifth position. You can also specify the name of the sheet.įor interoperability the ADDRESS and INDIRECT functions support an optional parameter to specify whether the R1C1 address notation instead of the usual A1 notation should be used. You can determine whether the address is interpreted as an absolute address (for example, $A$1) or as a relative address (as A1) or in a mixed form (A$1 or $A1). Returns a cell address (reference) as text, according to the specified row and column numbers. Returns a number representing a specific Error type, or the error value #N/A, if there is no error.
0 kommentar(er)
