Skip to Content
0
Former Member
Apr 07, 2010 at 09:21 PM

How to solve a circular reference with a Script Logic?

33 Views

Hello,

I have an Excel with some formulated cells. These cells refer to it selves leading to a circular reference. The circular reference is resolved by iterations until the difference between the value of a cell and its value after an iteration is less than 0.1.

Can I solve this with a Script Logic?

If so, is it advisable?

How could I do it?

Kind regards,

Miguel.