Laon amortization table

[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?

 

[Guest]

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

 

[Guest]

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

Thank you

 

[Guest]

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

 

[Guest]

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