I have the first few rows of my mortgage payments set up, and I want to know how to programmatically print the rest of the rows, as opposed to dragging the little corner box to output the rows.
This is important so that I can adjust the payment period, and automatically allow the total number of rows to change.
I think I have to use Array Formulas, but not sure how to print the next row the way dragging it or copy-pasting it would.
Also, I don't know how to give that array formula and ending condition.
The printing of new rows should only stop if the remaining principal gets to or below 0.