Manuals/calci/OFFSET

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