Manuals/calci/OFFSET
Jump to navigation
Jump to search
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 |
