refere to the cell to the left of a certain cell

[rantz]

How do I refere to the cell to the left of a certain cell when using
formula? I use formulas to transform the data in one column to another
column to another form.

Example:

=MIDB("cellref.offset(-1,0)",2,2)

It's the part "cellref.offset(-1,0)" that I don't know how to write.

It would be nice if I didn't have to click in the origin-cell every
time I change formula..

 

[Bob Phillips]

OFFSET(cell,0,-1)

will get the cell to the left

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[rantz]

ok, that's a good start. The thing is that I want excel to read the
left cell regardless of were I put the formula. So insted of "cell" I
want something like "the cell the formula is in"

OFFSET("this cell",0,-1)

 

[Bob Phillips]

Just put the address of the cell you put it in, like

=OFFSET(B1,0,-1)

and it updates as you copy it.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Niek Otten]

This happens automatically.
If you're in cell A2 and you type =A1 and then copy that formula to A3, it
will have changed there to =A2