Select value from list so that difference is minimized

[daumebtb]

Hi guys,

another day another problem.

I'm trying to find a way to mimic the Excel goal seeking function for the following problem:

Column A = 9.000.000
Column B = 3%
Column C = 1%
Column D = ???
Column E = (B / C) * D

Goal seeking: select from a list of values (in 250.000 increments(0, 250.000, 500.000, ....), for instance given in column F) the value that minimizes the difference between Column A and Column E

I hope you can help me with this one. Thanks in advance!

[ChemistB]

In D2
=E2*C2/B2+250000
In E2
=MIN(ABS(B2/C2*INDEX($I$1:$I$50,)-A2))

[daumebtb]

Thanks ChemistB,

actually I didn't even need solver or iteration for my problem --> C / B * A