Relative cell reference?

[j***@gmail.com]

I realize that with a relative cell reference, Excel will automatically adjust the address if I insert columns/rows, etc.

But I'm trying to accomplish something different than that.

Say that I have two cells H10 and H11, currently I have a formula in H11 like this: =IF(H10=0, "this", "that").

But I want to write a formula that translates to something like "If the cell 1 to the left of this current cell and in this current row is 0, then "this", otherwise "that.""

How do I do that?

[Harlan Grove]

***@gmail.com wrote...
...

Post by j***@gmail.com
Say that I have two cells H10 and H11, currently I have a formula in H11 like
this: =IF(H10=0, "this", "that").
But I want to write a formula that translates to something like "If the cell
1 to the left of this current cell and in this current row is 0, then "this",
otherwise "that.""

...

One way, but it uses volatile functions,

=IF(INDIRECT("RC[-1]",0),"this","that")