Difference between revisions of "Manuals/calci/OFFSET"
Jump to navigation
Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''OFFSET'''(Reference, Rows, Columns, Height, Width) where, '''Reference''' - represents the referencefrom b...") |
(No difference)
|
Revision as of 21:41, 24 October 2013
OFFSET(Reference, Rows, Columns, Height, Width)
where,
Reference - represents the referencefrom base of the offset.
Rows - the number of rows, up or down.
Columns - the number of columns, to the left or right.
Height - the height, in number or rows.
Width - the width, in number of columns.
It returns a refrence to a range i.e a specified number of rows and column from a cell.
If height or width is omitted, it cosider as a Reference.
OFFSET
Lets see an example in (Column3, Row3)
=OFFSET(B2,2,1,1,1)
OFFSET returns 9.
Syntax
Remarks
Examples
Description
Column1 | Column2 | Column3 | Column4 | |
Row1 | 1 | 7 | ||
Row2 | 2 | 8 | ||
Row3 | 3 | 9 | 9 | |
Row4 | 4 | 10 | ||
Row5 | 5 | 11 | ||
Row6 | 6 | 12 |