If I had the "necessary data" I wouldn't need circular references. When I get a suggested answer, I cross check it extensively to see if it fits the rest of the related calculations. If so, I use it. If not, I try again or change my approach. For me, Excel has provided a very reliable solution to problems where I have one too many unknowns, but I never take a suggested solution at face value without extensive testing.


Mac Pro dual Quad-Core Intel Xeons Early 2008; 16GB RAM; MacOS X 10.11.6, iOS 9.3.5