Excel address function

Version in which ADDRESS function can work:

Excel ADDRESS function will work in Excel for Android phones Excel Mobile Excel Starter Excel 2016 Excel 2013 Excel 2010 Excel 2007 Excel 2016 for Mac Excel for Mac 2011 Excel Online Excel for iPad Excel for iPhone Excel for Android tablets .

About excel ADDRESS function:

The Excel ADDRESS function returns a text  of cell address based on the given row and column number.

Syntax for excel ADDRESS Function:

=ADDRESS(row_num, column_num, [abs_num], [a1], [sheet_text])

Parameters:

row_num: The row number to use in the reference.

column_num: The column number to use in the reference.

abs_num: Optional argument which specifies absolute or relative reference. (Default absolute reference.)

[a1] :An optional logical argument that defines the reference style (A1 style or R1C1 style).

[sheet_text] : An optional text argument that specifies the sheet name.

Using ADDRESS function:

Finally, with different arguments combination to use address function is given with the example.

FormulaResultComment
 =ADDRESS(1,1)$A$1This will show of first row first column
 =ADDRESS(1,1,1)$A$1This will show first row first column with absolute reference.
 =ADDRESS(1,1,2)A$1This will show first row first column with absolute row/relative column reference.
 =ADDRESS(1,1,3)$A1This will show first row first column with relative row/absolute column reference.
 =ADDRESS(1,1,4)A1This will show first row first column with relative reference.
 =ADDRESS(1,1,1,0)R1C1This will show first row first column with absolute reference and R1C1 format.
 =ADDRESS(1,1,1,1)$A$1This will show first row first column with absolute reference and A1 format.
 =ADDRESS(1,1,1,1, “Sheet1”)Sheet1!$A$1This will show first row first column with absolute reference and A1 format with sheet name.

excel address function

 

Leave a Reply

Close Menu
×

Cart