On UrbanPro

View My Profile       Proud to be a Teacher       Write a Review  

Friday, August 22, 2014

ADDRESS Function in MS-Excel




D
E
3
Type a column number :
2
4
Type a row number :
3
5
Type a sheet name :
Hello



7
$B$3
 =ADDRESS(F4,F3,1,TRUE)
8
B$3
 =ADDRESS(F4,F3,2,TRUE)
9
$B3
 =ADDRESS(F4,F3,3,TRUE)
10
B3
 =ADDRESS(F4,F3,4,TRUE)



12
R3C2
 =ADDRESS(F4,F3,1,FALSE)
13
R3C[2]
 =ADDRESS(F4,F3,2,FALSE)
14
R[3]C2
 =ADDRESS(F4,F3,3,FALSE)
15
R[3]C[2]
 =ADDRESS(F4,F3,4,FALSE)



17
Hello!$B$3
 =ADDRESS(F4,F3,1,TRUE,F5)
18
Hello!B$3
 =ADDRESS(F4,F3,2,TRUE,F5)
19
Hello!$B3
 =ADDRESS(F4,F3,3,TRUE,F5)
20
Hello!B3
 =ADDRESS(F4,F3,4,TRUE,F5)

What Does It Do ?
This function creates a cell reference as a piece of text, based on a row and column
numbers given by the user.
This type of function is used in macros rather than on the actual worksheet.

Syntax
=ADDRESS(RowNumber,ColNumber,Absolute,A1orR1C1,SheetName)
The RowNumber is the normal row number from 1 to 16384.
The ColNumber is from 1 to 256, cols A to IV.
The Absolute can be 1,2,3 or 4.
   When 1 the reference will be in the form $A$1, column and row absolute.
   When 2 the reference will be in the form A$1, only the row absolute.
   When 3 the reference will be in the form $A1, only the column absolute.
   When 4 the reference will be in the form A1, neither col or row absolute.
The A1orR1C1 is either TRUE of FALSE.
   When TRUE the reference will be in the form A1, the normal style for cell addresses.
   When FALSE the reference will be in the form R1C1, the alternative style of cell address.
The SheetName is a piece of text to be used as the worksheet name in the reference.
   The SheetName does not actually have to exist.

Popular Posts