H
Heidi
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 coputing to stop after that number.
Thank you to anyone who can help,
Heidi
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 coputing to stop after that number.
Thank you to anyone who can help,
Heidi