Hey!

I need a help with my assigment.

I have a table, where I need to calculate the interest rate payments.

So, I have the interest rate and a number of years. Then I created a new table, to calculate the ending principal balance. The table goes down-down and ends up with 0 balance, which is correct.

But, here goes the problem, I need somehow a table to change in respect to the change of the number of years. For example, if I put 10 years of payment, the table would be much longer, but instead of drugging the formula down, so that it would show my numbers, I want my table to do it automaticaly.

Is there any way to make it this way???

thx a lot!

I need a help with my assigment.

I have a table, where I need to calculate the interest rate payments.

So, I have the interest rate and a number of years. Then I created a new table, to calculate the ending principal balance. The table goes down-down and ends up with 0 balance, which is correct.

But, here goes the problem, I need somehow a table to change in respect to the change of the number of years. For example, if I put 10 years of payment, the table would be much longer, but instead of drugging the formula down, so that it would show my numbers, I want my table to do it automaticaly.

Is there any way to make it this way???

thx a lot!

## Comment