Microsoft Office Tutorials and References
In Depth Information
Using Numbers with OFFSET to Describe a Range
Figure 12.36.
Figure 12.36. These
These OFFSET
functions return a single cell that is a certain
number of rows and columns away from cell C5.
OFFSET functions return a single cell that is a certain
number of rows and columns away from cell C5.
height
height This is the height, in number of rows, that you want the re-
turned reference to be. heightmust be a positive number.
width
width This is the width, in number of columns, that you want the re-
turned reference to be. widthmust be a positive number. If heightor
widthis omitted, Excel assumes it is the same height or width as refer-
ence.
Search JabSto ::




Custom Search