Investment Studio > Expressions > Functions > Reference > OFFSET

reference offset(reference base_reference, integer rows, integer columns, integer height = 0, integer width = 0)

Returns the base_reference (which may be to a single cell or to a cell range) offset by the specified number of rows and columns and optionally resized to the specified height and width.

If specified, height and width must be >= 0; 0 (the default value) means "unchanged".

Examples

=column(offset(a1, 2, 3))

returns 4 (column 1, offset by 3);

=row(offset(a1, 2, 3))

returns 3 (row 1, offset by 2);

=offset(a1, 2, 3)

equals

=D4

and returns the value of cell D4;

=offset(a1, -1, -1)

is an error (row and column coordinates must be > 0);

=offset(a1:c3, 2, 3)

equals

=D3:F5

or, equivalently,

={{D3, E3, F3}, {D4, E4, F4}, {D5, E5, F5}}

See also address, column, row.