Trial and error formula's
 

I wish to have a formula test a certain value against afew others then if it
does nor meet up to it trys again, what i have done so far is:

IF(Value2-Brokarage2-Brokarge1Value1,Value2, Here i want it to set value 2
to value2+0.01 then try again.

Many Thanks

You may find what you want with Goal Seek. Take a look at Excel's Help File


"LFrawley" wrote:

I wish to have a formula test a certain value against afew others then if it
does nor meet up to it trys again, what i have done so far is:

IF(Value2-Brokarage2-Brokarge1Value1,Value2, Here i want it to set value 2
to value2+0.01 then try again.

Many Thanks

Unfortunatly goal seek wont allow anything but a static goal, I need it to
find a goal dependant on other values that are variable

"Duke Carey" wrote:

You may find what you want with Goal Seek. Take a look at Excel's Help File


"LFrawley" wrote:

I wish to have a formula test a certain value against afew others then if it
does nor meet up to it trys again, what i have done so far is:

IF(Value2-Brokarage2-Brokarge1Value1,Value2, Here i want it to set value 2
to value2+0.01 then try again.

Many Thanks