Change Cell value from 0.01 to 1, until condition met

[lugburz]

Hello guys,

i have 1 noob question.

i want to change A1 value from 0.01 to 1, until A2 > A3. Both A2 and A3 values are dependent on A1.


thanks in advance

[Special-K]

Think you need to expand on this.

"I want to change the value from 0.01 to 1"
What do you mean by that? If you change it to 1 it will be 1 from then on. There's no "until". Once it is "changed" to 1 it will stay as 1.
It has no reflection on A2 being greater than A3.

So do you mean you want to add 0.01 to A1 until it A2 > A3 (in which case that's what you should say) or do you mean something else?

[lugburz]

for example:

A1 = 1, in this case A2 = 10 and A3 = 15
A1 = 2, in this case A2 = 12 and A3 = 13
A1 = 9, in this case A2 = 16 and A3 = 9

i want to continue changing A1 values (min 1 - max 20) and stop when A2 > A3.

[Special-K]

In those examples there's no pattern to A2 and A3 even though they are dependent on A1.

So what should A2 and A3 be when A1 is 3 ?

[lugburz]

why does that patter matter?

i just want to change A1 value from 1 to 20, for every value compare A2 to A3 and stop if A2 > A3.

[mikerickson]

Why does the pattern matter? Because there is a good chance that one can derive the value between .01 and 1 which will return the desired result, rather than iterating for it. (Its also possible that no value in that range will give the desired result)


Have you looked a Goal Seek.

[Special-K]

@lugburz:

YOU SAY A1 WILL HAVE VALUES FROM 1 TO 20.
YOU'VE SUPPLIED RESULTS FOR A2 AND A3 WHEN A1 IS 1, 2 AND 9.

HOW ARE WE SUPPOSED TO KNOW WHAT THE VALUES IN A2 AND A3 ARE WHEN YOU DON'T TELL US????
IF THERE WAS A PATTERN WE COULD PERHAPS WORK OUT A FORMULA.
AS IT STANDS AT THE MOMENT WE'LL HAVE TO GUESS.

OF COURSE, IT DOESN'T MATTER TO ME ONE IOTA WHETHER YOU SOLVE THIS OR NOT.
BUT I EXPECT IT DOES TO YOU...

SO THE ONUS IS ON YOU TO SUPPLY AS MUCH INFORMATION AS POSSIBLE IF YOU WANT IT SOLVED RATHER THAN QUESTION THE METHODS TAKEN TO ACHIEVE THIS.