3 Replies Latest reply: Nov 8, 2010 7:30 PM by Boberino
Boberino Level 1 Level 1 (30 points)
I am trying to use the OFFSET() function to access the cell just to the left of the current cell, as follows: (Where # is the reference to the current cell.)

=OFFSET(#,0,-1)

How do I reference my current cell without using an absolute reference?

Thanks in advance.

Quad-Core Intel Xeon with 2 - 3 GHz Processors (Mac Pro), Mac OS X (10.6.3)