Groups | Search | Server Info | Login | Register

Groups > comp.apps.spreadsheets > #48

Relative cell reference?

Show all headers | View raw

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?

Back to comp.apps.spreadsheets | Previous | Next — Next in thread | Find similar

Thread

Relative cell reference? johndhupp@gmail.com - 2013-01-31 11:24 -0800
  Re: Relative cell reference? Harlan Grove <hrlngrv@gmail.com> - 2013-02-17 02:46 -0800

csiph-web