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

Circular Reference Forumlas
 

http://www.mcgimpsey.com/excel/accumulator.html



--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com

"acebrown" wrote in
message ...

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