Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Relative cell reference?
21 views
Skip to first unread message
john...@gmail.com
Jan 31, 2013, 2:24:51 PM1/31/13
to
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?
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
Feb 17, 2013, 5:46:09 AM2/17/13
to
john...@gmail.com wrote...
...
One way, but it uses volatile functions,
=IF(INDIRECT("RC[-1]",0),"this","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.""
...
>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")
0 new messages