Syntax of the OffSet Function??

[GBL]

Hi:
All my references do not have an explanation of the OFFSET function. I
believe it consists of three parts. Can someone please give me the syntax
and how it may be used?

 

[Frank Kabel]

Hi
the Excel help should give you this syntax without any problem?

 

[Arvi Laanemets]

Hi

=OFFSET(StartCell,RowsDown,ColumnsLeft,NumberOfRows,NumberOfColumns)

With only 3 first parameters given, a cell value is returned. P.e.
=OFFSET(C2,3,0)
returns the value from cell C5.
=OFFSET(A1,1,3)
returns the value from cell D2.

When the 4. and 5. parameters are given, a reference to cell range is
returned. P.e.
=OFFSET(B2,,,10,1)
returns the reference to range B2:B11.
=OFFSET(B1,2,2,1,5)
returns the reference to range D37, etc.

 

[GBL]

Hi:
Thank you for your help!

Hi

=OFFSET(StartCell,RowsDown,ColumnsLeft,NumberOfRows,NumberOfColumns)

With only 3 first parameters given, a cell value is returned. P.e.
=OFFSET(C2,3,0)
returns the value from cell C5.
=OFFSET(A1,1,3)
returns the value from cell D2.

When the 4. and 5. parameters are given, a reference to cell range is
returned. P.e.
=OFFSET(B2,,,10,1)
returns the reference to range B2:B11.
=OFFSET(B1,2,2,1,5)
returns the reference to range D37, etc.