Microsoft Office Tutorials and References
In Depth Information
OFFSET
sales for Asia to Year 2. The formula: =OFFSET(C5,0,2) where C5 is the current location, or
ground zero. The number of rows down is 0, and 2 is the number of columns over. The height of
the return is the first row and the first column from the new position. If the row reference was 2,
the return would have been 9,878. However, the result returns the value in cell E5 of 8,696.
It’s important for you to note that the examples don’t need the last two arguments (height and
width). They are assumed to be 1 and 1 if they are omitted. When used within another function,
the last two arguments help create a new range height and width starting at the new offset
position. Using height and width numbers other than 1 in a cell containing just an offset formula will
result in an error. If OFFSET is used inside of another function that is expecting to see a reference,
then OFFSET returns the address and not the value.
The range or cell of adjacent cells on which you want to base the offset.
REFERENCE
The number of rows up or down you want the base to refer or offset to.
ROWS
The number of columns left or right you want the base to refer or offset
to. For example, using three would mean the upper-left cell is three
columns to the right of the reference.
COLUMNS
(Optional) The height in the number of rows that you want the reference
to return. This must be a positive number.
HEIGHT
(Optional) The width in the number of columns that you want the reference
to return. This must be a positive number.
WIDTH
A
Reference
Figure 9.12
The OFFSET function
returns a location offset
from the current
location on the worksheet.
C
Columns
B
Rows
D
Return
Search JabSto ::




Custom Search