Groups | Search | Server Info | Login | Register
Groups > comp.apps.spreadsheets > #48
| X-Received | by 10.224.211.193 with SMTP id gp1mr4929090qab.4.1359660292111; Thu, 31 Jan 2013 11:24:52 -0800 (PST) |
|---|---|
| X-Received | by 10.49.96.196 with SMTP id du4mr1000310qeb.37.1359660291970; Thu, 31 Jan 2013 11:24:51 -0800 (PST) |
| Path | csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!news.glorb.com!p13no9252093qai.0!news-out.google.com!k2ni3907qap.0!nntp.google.com!p13no7520171qai.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail |
| Newsgroups | comp.apps.spreadsheets |
| Date | Thu, 31 Jan 2013 11:24:51 -0800 (PST) |
| Complaints-To | groups-abuse@google.com |
| Injection-Info | glegroupsg2000goo.googlegroups.com; posting-host=76.208.21.53; posting-account=mNNwrQoAAAAzWL74wbhrcku0jgsoGZZA |
| NNTP-Posting-Host | 76.208.21.53 |
| User-Agent | G2/1.0 |
| MIME-Version | 1.0 |
| Message-ID | <e0e5e99d-b4c0-4ef1-91df-3edc006e6918@googlegroups.com> (permalink) |
| Subject | Relative cell reference? |
| From | johndhupp@gmail.com |
| Injection-Date | Thu, 31 Jan 2013 19:24:52 +0000 |
| Content-Type | text/plain; charset=ISO-8859-1 |
| Xref | csiph.com comp.apps.spreadsheets:48 |
Show key headers only | 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
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