formula and offset

[GS]

in a formulate, how do I get the value on the cell 1 column to left, and
next row?

 

[Vasant Nanavati]

Hit:
The "equals" sign
The "left arrow" key
The "down arrow" key
The "enter" key
______________________________________________________________________

 

[Guest]

if the cell in question is C2, try
=OFFSET(C2,1,-1)