Laon amortization table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My loan term is 3.5 years. How can i calculate payments when the table will
only accept full years in the loan term cell?
 
Why will the loan term cell only accept whole numbers? Is Data Validation
turned on? Give us more details about the spreadsheet you're using.

Dave
 
I downloaded the Loan Amortization Schedule from Excel 2003...what is data
validation?

Thank you
 
Can you provide a link to the template so someone can download and take a
look at it? Data validation is a tool used in Excel to restrict entries in a
cell to a specified list of values, such as whole numbers.

Dave
 
I just went onto Office Help online and found a loan amortization table that
accepted partial years...the version I was using before I found through the
help menu while I was in Excel. I think the one i found online is going to
work...thank you
 
You must log in or register to reply here.

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

What happened to the loan amortization work sheets? 1
CUMIPMT 0
Weighted Average Life 1
Help to create amortization schedule 0
Help with Loan Calc 1
need a vehicle loan amortization 6
loan amortizations worksheets 2
Is there a loan amortization schedule with balloon at final pmt? 4

Back
Top