circular formula gives different values

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.
 
L

Luke M

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

How do I locate a circular formula? 2
Word macro that can call cells out of Excel for a find and replace 0
Circular reference, Indirect, and Sum 3
Recalculating in a circular reference 3
circular reference - iteration 5
Help! Need to compare 2 sets of data 1
Formula result and displayed result are different 4
Finding Circular References 2

Top