Função do Google Sheets

ADDRESS

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

Gerar uma fórmula com IA A mesma função no Excel

Esta função funciona no Google Sheets da mesma forma que no Excel — mesma sintaxe e argumentos.

Sintaxe

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

Argumentos

row_numobrigatórioThe row number to use in the cell reference.
column_numobrigatórioThe column number to use in the cell reference.
abs_numopcionalSpecifies the type of reference (1=absolute, 2=abs row/rel col, 3=rel row/abs col, 4=relative).

Exemplos

=ADDRESS(1, 1)

Resultado: $A$1

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

=ADDRESS(2, 3, 4)

Resultado: C2

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

Perguntas frequentes

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.

Funções relacionadas

INDIRECT INDEX OFFSET