40 year loan amortization schedule

R

Roy

I am using Excel 2003 and trying to get the existing template for a loan that
will be amortized over 40 years. Excel will not let me enter a number above
30. How do I circumvent this problem?
 
G

Gord Dibben

Select that cell(D8) and Data>Validation.

Remove or change the validation rule that limits you to 30 years.

You will also have to edit any of the range names that refer to row 378

Add 120 to those..................498

Then copy the formulas from row 378 down to row 498

Nothing to it<g>


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top