Trial and error formula's

L

LFrawley

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-Brokarge1>Value1,Value2, Here i want it to set value 2
to value2+0.01 then try again.

Many Thanks
 
L

LFrawley

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