Hi All, I am quite stuck in an operation where I have to calculate a sum using circular reference. Though in Excel , it's quite easy (or already managed by excel itself) to use circular reference but I am not sure how to implement this thing in C#. The problem is like this: I have to sum a whole range of cells and then two values in cells use the sum itself for their own calculation.that is, if i have sum = num1 + num2 + num3 + num4, then num2 = someVariable + sum/someVariable2; and similarly num4 also uses sum in its value. To start with I guess I should take sum = 0 and then calculate num2 and num4, that will give me a new sum that further can give me new value for two variables and finally I can get final sum. But I am quite confused whether this approach is correct or not. Please suggest!
