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
|