Puzzled by statement about R1C1 style in "Escape from Excel Hell"

[[email protected]]

Hi,

I recently bought the book "Escape from Excel Hell" 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):

"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!"

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

[Bryan Hessey]

I have not read the book, but can only asume the author meant to use the equivalant R1C1 formula, ie
"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."

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

--

Hi,

I recently bought the book "Escape from Excel Hell" 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):

"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!"

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

[Dave Peterson]

It 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.



[email protected] wrote:
>
> Hi,
>
> I recently bought the book "Escape from Excel Hell" 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):
>
> "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!"
>
> 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

--

Dave Peterson

[[email protected]]

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