![]() ![]() 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 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |