Need some sort of circular reference, but without an error
Posted by Bob on July 10, 2001 1:35 PM
I am trying to set up a spreadsheet so that the user can enter a value in one of two columns (current billing or percent complete)and the other column will automatically calculate the correct value via a formula. The problem is that creates a circular reference. Following is a simplified spreadsheet showing what I mean. Any ideas?
A B C D E
Budget Previous Current Completed Percent
$50.00 $15.00 $22.00 =b2+c2 Need calc'd
$40.00 $10.00 Need =b3+c3 50%