Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.misc
Bryan Hessey
 
Posts: n/a
Default Puzzled by statement about R1C1 style in "Escape from Excel Hell"


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

--

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



--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile:
http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=532066

  #4   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
Excel Report Using IF Statement? Marc Excel Discussion (Misc queries) 3 January 11th 05 08:38 AM
SQL Statement and Excel DavidM Charts and Charting in Excel 3 January 7th 05 01:53 PM
How to format a number in Indian style in Excel? Victor_alb Excel Discussion (Misc queries) 2 December 21st 04 05:21 AM
Excel should not be an MDI style application. Robert Brown Excel Discussion (Misc queries) 4 December 14th 04 01:18 AM


All times are GMT +1. The time now is 08:29 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"