Funzione di Google Sheets

ADDRESS

Creates a cell reference as text, given specified row and column numbers.

Genera una formula con l'IA La stessa funzione in Excel

Questa funzione funziona in Google Sheets esattamente come in Excel — stessa sintassi e stessi argomenti.

Sintassi

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).

Argomenti

row_numobbligatorioThe row number to use in the cell reference.
column_numobbligatorioThe column number to use in the cell reference.
abs_numfacoltativoSpecifies the type of reference (1=absolute, 2=abs row/rel col, 3=rel row/abs col, 4=relative).

Esempi

=ADDRESS(1, 1)

Risultato: $A$1

Returns the absolute reference for the cell at row 1, column 1.

=ADDRESS(2, 3, 4)

Risultato: C2

Returns the relative reference for the cell at row 2, column 3.

Domande frequenti

Can ADDRESS return a reference to another sheet?

Yes, by providing the sheet_text argument, you can include the sheet name in the resulting reference string.

Funzioni correlate

INDIRECT INDEX OFFSET