I am working on a spreadsheet to determine the number of monthly payments until a debt is paid off. The monthly payments change based on several values. I can easily find the number of payments needed to pay off the debt.

However, it doesn't display real nice. I have to drag the row of equations down manually and then "eyeball" where the payments have reached the right level. This results in many unecessary rows after the final payment has been made.

Is there a way to dynamically "drag" the equations down until a certain field value is reached and then "stop dragging" the row? This would result in the final row of equations being the "answer" and not displaying any more information.

Thanks in advance.

-steve

This message was edited by snerheim on 2002-08-23 13:53