formula and offset
 

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

formula and offset
 

Hit:
The "equals" sign
The "left arrow" key
The "down arrow" key
The "enter" key
__________________________________________________ ____________________


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

formula and offset
 

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


"GS" wrote:

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