S
sc
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?
only accept full years in the loan term cell?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Dave F
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
turned on? Give us more details about the spreadsheet you're using.
Dave
S
sc
I downloaded the Loan Amortization Schedule from Excel 2003...what is data
validation?
Thank you
validation?
Thank you
D
Dave F
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
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
S
sc
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
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