Microsoft® Excel® 2010 Formulas & Functions Inside Out

ADDRESS()

Syntax. ADDRESS(row_num,column_num,Abs,a1,sheet_text)

Definition. This function converts arguments into a text cell reference.

Arguments

• row_num and column_num (required). The coordinates of the address. These arguments can be any expression that can be evaluated to a number that will create a valid reference (values from 1 through 65,536 for row_num and from 1 through 256 for column_num in Excel 2003 and earlier, and a maximum of 1,048,476 for row_num and 16,384 for column_num in Excel 2007 and Excel 2010).

• Abs (optional). Indicates whether a reference is absolute or relative. Table 10-2 lists the valid arguments. The default value is 1.

Table 10-2. Reference Style Numbers

Reference Style	Abs Argument
Absolute row and column	1
Relative column, ...