I posted this under the functions group and did not get a
response. I called a number where they said I can't do
what I want to do without visual basic. Should I forget
it, or is there a formula someone could just give me to
use?

Thanks,
H




I'm trying to creat a formula that keeps doing the same
test in a single cell by increasing one of the variables
by .01 each time until the sum of the overall equation
becomes than a given number. I'm able to do this on
multiple lines, but when you change the given
information, then the "answer" is on a different line
each time. I need it to do the multiple computations in
the same cell. Is that possible?
Here is a simplified example:

A B C D

4 1 4 50


C = A*B

If A + C < D, then increase B by 1 each time until the
answer is D and that is the number for which you are
looking. I need the computing to stop after that number
and let the value of the cell just equal that final
number.

Thank you to anyone who can help,

Heidi

..