Hallo Experts,

Sorry I cannot upload the excel file, b ut will try to explain the situation.

I had a circular reference problem to solve that I used iteration and the problem was solved but on giving a big direct input no.(for eg. 60000) the solution diverges and give the result #Value. If I slowly increase the value (for eg. 10000, 20000 so on) then it gives the result.

My question is How can I automatically increase the value to a desired value in the input cell per iteration. So that I don't need to do that manually and It will increase upon iteration.


Thanks in advance!