What is the syntax of an address of cell immediately to the left of a given
cell ?

Can you please also write syntax of an address of cell immediately to the
right of a given cell. Perhaps that will help me understand and maybe even
figure out an address of a cell immediately below or above a given cell.

Also, can a cell that is more than one cell away also be addressed in a
similar format ?



Peter

One way

=CELL("address",OFFSET(D2,,-1))

will return C3


--

Regards,

Peo Sjoblom



"Swiatkowski Peter" <(E-Mail Removed)> wrote in message
news:LI-dncp-gf-BZz_eRVn-(E-Mail Removed)...
> What is the syntax of an address of cell immediately to the left of a
given
> cell ?
>
> Can you please also write syntax of an address of cell immediately to the
> right of a given cell. Perhaps that will help me understand and maybe even
> figure out an address of a cell immediately below or above a given cell.
>
> Also, can a cell that is more than one cell away also be addressed in a
> similar format ?
>
>
>
> Peter
>
>