Creates a cell reference as text, given specified row and column numbers.
Bu işlev, Google E-Tablolar'da Excel'deki gibi çalışır — aynı söz dizimi ve bağımsız değişkenler.
ADDRESS(row_num, column_num, [abs_num], [a1], [sheet_text])The ADDRESS function is used to construct a cell reference string based on numeric row and column coordinates. It allows you to specify the reference type (absolute or relative) and the reference style (A1 or R1C1).
=ADDRESS(1, 1)Sonuç: $A$1
Returns the absolute reference for the cell at row 1, column 1.
=ADDRESS(2, 3, 4)Sonuç: C2
Returns the relative reference for the cell at row 2, column 3.
Yes, by providing the sheet_text argument, you can include the sheet name in the resulting reference string.