I've been searching the boards for hours on this and figured that it is time to just ask. I have a feeling that this will be a very simple answer.
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
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