How to use ADDRESS Function in Excel
Description
The ADDRESS function to obtain the address of a cell in a worksheet, returns the address for a cell based on a given row and column number.
For example, ADDRESS(4,2) returns $B$4.
4 – indicates row 4 , 2 indicates Column B ( First column A second Column B )
Syntax
=ADDRESS(row_num, column_num, [abs_num], [a1], [sheet_text])
Arguments
row_num Required.
row_num must be specified. That must be a numeric value.
A numeric value that specifies the row number to use in the cell reference.
column_num Required. A numeric value that specifies the column number to use in the cell reference.
[abs_num] Optional. A numeric value that specifies the type of reference to return.
[a1] [optional] The reference style, A logical value that specifies the A1 or R1C1 reference style. Defaults to A1 style.
[Sheet-text] – [optional] The name of the worksheet to use. Defaults to current sheet.
[abs_num] key
1 – Absolute [Default]
2 – Absolute row / Relative Column
3 – Relative Row / Absolute Column
4 – Relative
Return Value
A cell address in the current or given worksheet.
Examples
=ADDRESS(1,2) returns $B$1 [abs_num] 1 is default =ADDRESS(1,2,2) returns B$1 [abs_num] 2 =ADDRESS(1,2,3) returns $B1 [abs_num] 3 =ADDRESS(1,2,4) returns B1 [abs_num] 4
Popular post
-
Eclipse IDE – Create New Java Project.
Opening the New…
-
Start the project in android studio
Android Studio Open…
-
How to use ACOSH function in excel
The ACOSH function…
-
How to learn HTML – Header tag in html
H tags can…
-
Python program – best features
Python is the…