circular formula gives different values

  • Thread starter Thread starter jolly
  • Start date Start date
J

jolly

I have a circular reference in my worksheet where I get two sets of values
for the same input as the circular flips between two values. I have set the
iteration to 100 but the values in the sheet do not give the same answer each
time.
 
With no example of the formula you are using, it is much harder to see what
is going wrong. I would suggest changing iteration to 1, and then pressing
F9 to step through, and see if there is perhaps a repeat of one of the
values, or a 3rd unknown value that is appearing.
 

Ask a Question

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.

Ask a Question

Similar Threads

Recalculating in a circular reference 3
How do I locate a circular formula? 2
Circulair error message 2
Circular reference, Indirect, and Sum 3
change cell event using circular reference - not VBA! 3
circular reference warnings 1
circular reference - iteration 5
Circular 7

Back
Top