#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Circular Ref.

I have a figure that copys from C5, to C12, which is ok, but I want the
figure in C12 to be added to D12 and D12 to show the new total.
Does anyone know if this is possible?

Thanks
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,651
Default Circular Ref.

Yes, but circular references should be treated with caution. You'll need to
look at iterations.
http://office.microsoft.com/en-us/ex...662431033.aspx
--
David Biddulph

"storm01" wrote in message
...
I have a figure that copys from C5, to C12, which is ok, but I want the
figure in C12 to be added to D12 and D12 to show the new total.
Does anyone know if this is possible?

Thanks



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
Circular:G4? WTG Excel Worksheet Functions 4 April 20th 06 07:49 PM
Circular Referance John Vickers Excel Discussion (Misc queries) 2 February 15th 06 08:56 AM
Circular reference help please! [email protected] Excel Discussion (Misc queries) 1 February 9th 06 10:41 AM
Circular references R.Hocking Excel Worksheet Functions 1 February 2nd 06 06:51 PM
'circular reference' Rathika Excel Discussion (Misc queries) 2 January 26th 06 04:24 AM


All times are GMT +1. The time now is 02:04 AM.

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"