ExcelBanter - Formula to choose cell and then cell three rows down

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Formula to choose cell and then cell three rows down (https://www.excelbanter.com/excel-worksheet-functions/102521-formula-choose-cell-then-cell-three-rows-down.html)

Formula to choose cell and then cell three rows down

I am trying to write a formual that will take information from one cell and
then the cell 3 rows below it.

CLR

Formula to choose cell and then cell three rows down

=A1+OFFSET(A1,3,0)
or
=A1&" "&OFFSET(A1,3,0)

hth
Vaya con Dios,
Chuck, CABGx3

"mg" wrote:

I am trying to write a formual that will take information from one cell and
then the cell 3 rows below it.

All times are GMT +1. The time now is 09:13 PM.