Microsoft Office Tutorials and References
In Depth Information
ADDRESS
ADDRESS
Given specified row and column numbers, ADDRESS creates a cell address as text.
=ADDRESS(row_num,column_num,abs_num,A1,sheet_text)
The ADDRESS function returns the address of the cell in relative and in absolute form. This
function is mostly used in combination with other functions to produce an address where the
row or column (or both) are not known or may change. For example:
=ADDRESS(MATCH(MAX(D2:D100),D2:D100,0),4)
ROW_NUM is the row number to use in the cell reference.
COLUMN_NUM is the column number to use in the cell reference.
ABS_NUM specifies the reference type to return.
Abs_Num Return Type
1 or omitted Absolute
2 Absolute: Relative Column
3 Relative Row: Absolute Column
4 Relative
=ADDRESS(2,2) returns the result =$B$2 Absolute Reference.
=ADDRESS(2,2,2) returns the result =B$2 Absolute Row, Relative Column.
=ADDRESS(2,2,3) returns the result =$B2 Absolute Column, Relative Row.
=ADDRESS(2,2,4) returns the result =B2 Relative Column, Relative Row.
AREAS
Based on a reference, AREAS returns the number of areas.
=AREAS(reference)
The AREAS function returns the number of areas in a reference. For example, the formula
=Areas(B3:B10) results in 1, because there is just one range selected. The formula
= Areas((B3:B10,C3:C10)) would result in two because there are two ranges referenced.
When inheriting a workbook with range names, you can audit the range names with the
AREAS function to specify the number of references the named range is referencing. For
example, if you have a range name called Costs that referred to 1998 costs in A3:A100 and
1999 costs in B3:B100, =AREAS(Costs) would equal 2.
This is the reference to a cell or range of cells the formula refers
to. It can also refer to multiple areas.
REFERENCE
Search JabSto ::




Custom Search