iterate till will converge

[white_flag]

Hello

I like to iterate an cell (D6) till (D21+I10=N15) will converge (equilibrium reached). D21=D6*formula, I10=D6*formula, N15=D6*formula.

 

[shg]

You could perhaps do this with iteration, but with Solver, in another cell, enter

=(D21+I10-N15)^2

Set Solver to minimize that by changing D6.

 

[white_flag]

.. and without solver?

 

[shg]

Dunno enough about your problem. I tend to avoid iteration; it's usually there for just one formula in a workbook.

 

[white_flag]

it is like this
D6 - to be iterated (1 till 100 with 0.1 steps)
D21=D6+5.3
I10=D6+10.25
N15=D6+18.2

wen
D21+I10=N15 -- stop

 

[Weaver]

Is it not possible to rearrange your formulas so the solution gives you your convergence?

With there being a square involved, the answer will be +/-

 

[white_flag]

this is the excel file:

http://www.megaupload.com/?d=0LPXR2HV

 

[shg]

Why not just solve it?

D6+5.3 + D6+10.25 = D6+18.2

D6 =18.2 - 5.3 - 10.25 = 2.65

 

[white_flag]

that was just an example. The real situation I find it (for me) difficult. (I put an link with the excelfile)

 

[shg]

Very nice workbook!

I'm not seeing a way to do this via iteration at a glance, but will look back at it this afternoon.