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