iteration formula

Hello,

I'm not very good at VBasic, but I'm looking to do the following:

In a cell, I would like to calculate a formula doing something like this:

FOR x=0.1 TO VALEUR(K14), INCREMENT=0.1
DO ((F14-x)*J23)-O23 = Y

UNTIL Y is the biggest, and then display the X value in the F69 cell and the Y in the G68 cell.

Any help would be very appreciated.
Thanks.
S.

Here's a For _ Next loop that will perform the calculation you described and return the max Y value to cell G68. But taking a closer look at your formula won't the first iteration always return the largest value for Y when x = 0.1?

Please Login or Register  to view this content.

HTH

I came up with an almost identical macro as bhofsetz. The formula (as written) is a linear equation, so based opon the values the maximum value for the result will either the very first pass, or the last. Here is a sample workbook that gets the same results without any iterations or macros.

If the formula is not supposed to be linear, then the macro and and iterations would be required to get an accurate result.



Lee

Thanks a lot to both of you. I'll have a closer look at whhat you sent me.

Thanks again.
S.