Sheet reference to loan term

Have a look here:

http://www.vertex42.com/

Third one down is a Loan-amortization-schedule.xls
Lots to find - Google is your friend ;)

You could send me the problem sheet, if the file doesn't
help.


Regards
Robert McCurdy
"I go any way."

----- Original Message ----- 
From: "CathClaud" <claudcarADELPHIA.NET>
To: <EXCEL-GPEACH.EASE.LSOFT.COM>
Sent: Tuesday, October 31, 2006 3:10 PM
Subject: Sheet reference to loan term


> Have a sheet that starts with one entering the number
of years for the loan.
> JUST realized that when I enter the monthly payment, I
don't know how to
> reference back to the cell with the number of months to
have the sheet
> complete the payment / decreasing balance / interest
per month for the total
> number of months.  Had it initially set for 24 months
and then was asked to
> make it variable and got lost. "Lost in
Excel"
> -- 
> Claudia
> Excel 2K3 on PC
> Excel 2K4 on MAC
> Yes I go both ways 
> 
>
------------------------------------------------------------
--------------
> The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
> international's LISTSERV(R) software.  For
subscription/signoff info
> and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
>                             COPYRIGHT INFO:
> http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G

------------------------------------------------------------
--------------
The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
international's LISTSERV(R) software.  For
subscription/signoff info
and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
                             COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G