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
Peo Sjoblom - 16 Dec 2005 17:50 GMT
One way
=CELL("address",OFFSET(D2,,-1))
will return C3

Signature
Regards,
Peo Sjoblom
> What is the syntax of an address of cell immediately to the left of a given
> cell ?
[quoted text clipped - 7 lines]
>
> Peter