If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Loan Calculator for more than 30 years
I'm using the Loan Calculator (Amortization Schedule) that comes with
Microsoft Excel (I'm running Excel XP). I need to change it so that it will allow more than 30 years. I've changed the data validation in cell D8 (Loan Payment in Years) to allow for more than 30 (I set it at 100). What is the cell that's causing the problem that it still won't allow more than 30 years to calculate? I see the "Actual Number of Payments" never goes to more than 361 payments. Help, please!! -Ray |
#2
|
|||
|
|||
I'm using the Loan Calculator (Amortization Schedule) that comes with
Microsoft Excel (I'm running Excel XP). I need to change it so that it will allow more than 30 years. I've changed the data validation in cell D8 (Loan Payment in Years) to allow for more than 30 (I set it at 100). What is the cell that's causing the problem that it still won't allow more than 30 years to calculate? I see the "Actual Number of Payments" never goes to more than 361 payments. Help, please!! -Ray I forgot to mention that I've unprotected the worksheet and copied cells past the 360th payment. That's not what's causing the problem. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
loan calculator cells, P&I formulas do not copy to second cloumn | Mr. C | Worksheet Functions | 4 | March 5th, 2005 03:45 PM |
Adding a year(s) to a specific date | Rene | General Discussion | 4 | October 29th, 2004 03:20 AM |
CUMPRINC Function Returns #N/A | George Sullivan | Worksheet Functions | 14 | August 9th, 2004 04:43 PM |
Comparing y-t-d average between 2 years for each year without surpassing present year's week | Yvon | General Discussion | 3 | July 13th, 2004 04:07 PM |
Calculating Time employeed | Mark Graesser | Worksheet Functions | 4 | December 22nd, 2003 09:18 PM |