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!

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



--


Regards,

Peo Sjoblom

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

"acebrown" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>