View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
acebrown acebrown is offline
external usenet poster
 
Posts: 1
Default Circular Reference Forumlas


I'm working with three cells:
-original $ amount
-new $ amount (original+change)
-change (new-original)

I would like to be able to enter a number in either "new $ amount" or
"change" and have the opposite one populate. On top of that, I would
like the forumla to snap back into place if the entered number is
deleted. HELP! Thanks!


--
acebrown
------------------------------------------------------------------------
acebrown's Profile: http://www.excelforum.com/member.php...o&userid=36640
View this thread: http://www.excelforum.com/showthread...hreadid=563920