software

Hi,

I recently bought the book quot;Escape from Excel Hellquot; by Loren Abdulezer.
I like its brisk writing style and many examples. But I'm puzzled by
the following statement (from the sidebar on page 7):

quot;The R1C1 style formula isn't tied to which cell the formula is written
in. The formula =$A2 B3 appearing in D6 will not match the results of
the formula =$A2 B3 appearing in G17. You have two identical-looking
formulas meaning different things!quot;

When I tried this out in a new blank spreadsheet (once using Excel 2002
and again using Excel 2003) the formulas both work and both result in
the same values. To my eyes, they both look the same and they mean the
same.

Can anyone explain the quoted sentence?

Note: When I switched to R1C1 style, and entered the formula =$A2 B3 in
cells D6 and G17, the formulas were automatically converted to R1C1
style -- and looked very different in the two cells, as expected.

Thanks,
Bob Stromberg
Greenwich, NY
I have not read the book, but can only asume the author meant to use the
equivalant R1C1 formula, ie
quot;The R1C1 style formula isn't tied to which cell the formula is
written in. The formula =R[-7]C[-5] R[-6]C[-4] appearing in D6 will not
match the results of the formula =R[-7]C[-5] R[-6]C[-4] appearing in
G17.quot;

You cannot put =$A2 B3 into an R1C1 sheet, but must use the relative
addressing of =R[-4]C[-3] R[-3]C[-2]

Hope this helps

--
Wrote:
gt; Hi,
gt;
gt; I recently bought the book quot;Escape from Excel Hellquot; by Loren
gt; Abdulezer.
gt; I like its brisk writing style and many examples. But I'm puzzled by
gt; the following statement (from the sidebar on page 7):
gt;
gt; quot;The R1C1 style formula isn't tied to which cell the formula is
gt; written
gt; in. The formula =$A2 B3 appearing in D6 will not match the results of
gt; the formula =$A2 B3 appearing in G17. You have two identical-looking
gt; formulas meaning different things!quot;
gt;
gt; When I tried this out in a new blank spreadsheet (once using Excel
gt; 2002
gt; and again using Excel 2003) the formulas both work and both result in
gt; the same values. To my eyes, they both look the same and they mean
gt; the
gt; same.
gt;
gt; Can anyone explain the quoted sentence?
gt;
gt; Note: When I switched to R1C1 style, and entered the formula =$A2 B3
gt; in
gt; cells D6 and G17, the formulas were automatically converted to R1C1
gt; style -- and looked very different in the two cells, as expected.
gt;
gt; Thanks,
gt; Bob Stromberg
gt; Greenwich, NY--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: www.excelforum.com/member.php...oamp;userid=21059
View this thread: www.excelforum.com/showthread...hreadid=532066It sounds like you got the gist of his point.

To me, it just sounds like he's writing that the formula =$A2 B3 that looks the
same in A1 reference style will look different in R1C1 reference style--it'll
depend on what cell holds the formula.wrote:
gt;
gt; Hi,
gt;
gt; I recently bought the book quot;Escape from Excel Hellquot; by Loren Abdulezer.
gt; I like its brisk writing style and many examples. But I'm puzzled by
gt; the following statement (from the sidebar on page 7):
gt;
gt; quot;The R1C1 style formula isn't tied to which cell the formula is written
gt; in. The formula =$A2 B3 appearing in D6 will not match the results of
gt; the formula =$A2 B3 appearing in G17. You have two identical-looking
gt; formulas meaning different things!quot;
gt;
gt; When I tried this out in a new blank spreadsheet (once using Excel 2002
gt; and again using Excel 2003) the formulas both work and both result in
gt; the same values. To my eyes, they both look the same and they mean the
gt; same.
gt;
gt; Can anyone explain the quoted sentence?
gt;
gt; Note: When I switched to R1C1 style, and entered the formula =$A2 B3 in
gt; cells D6 and G17, the formulas were automatically converted to R1C1
gt; style -- and looked very different in the two cells, as expected.
gt;
gt; Thanks,
gt; Bob Stromberg
gt; Greenwich, NY

--

Dave Peterson

Thanks, Bryan and Dave, for your quick responses. --Bob