Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Puzzled by statement about R1C1 style in "Escape from Excel Hell"
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Puzzled by statement about R1C1 style in "Escape from Excel Hell"
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. 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Puzzled by statement about R1C1 style in "Escape from Excel Hell"
Thanks, Bryan and Dave, for your quick responses. --Bob
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Excel Report Using IF Statement? | Excel Discussion (Misc queries) | |||
SQL Statement and Excel | Charts and Charting in Excel | |||
How to format a number in Indian style in Excel? | Excel Discussion (Misc queries) | |||
Excel should not be an MDI style application. | Excel Discussion (Misc queries) |