Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|