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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Issue with conditional formatting - Formula changing 1
Help Required With IF AND Formula 2
How to properly read Value2 Range ? 5
Date lists 3
formulae in excel worksheets 4
Logical functions AND,OR in array formulas work ? 4
conditional formatting for ratios between rows? 3
Can I transpose data from rows to cols with a formula not pivot ta 1

Top