You can either fix the error by changing your formulae so that you do not
have a circular reference, typically by inserting an extra step.
for example calculate funds_before_interest, the interest on the
funds_before_interest and then funds_after_interest
Or if you really have a circular system you can use Iteration
(Tools-->Options-->Calculation-->Iteration), but be careful because this
tends to make it more difficult to find errors.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
