I think i am looking for a IF THEN funtion

[carrguy01]

I have a amortization schedule and i want to auto fill a cell that coresponds wirh the number of the last payment

i.e
a13 thru to a373 is istalments made
f13 thru to f373 is current balance
I6 is where i want the last instalment number to appear

The mortgage is for 30 years meaning there are 360 payments to be made. If there is a lump sum payment made in the first year the mortgage will be paid off sooner. I want that number to appear in cell I6.

Is this possible?

 

[Trevor G]

Have you looked at the PMT Function it stands for Payment Monthly Terms. See samples from the Help File.

Excel Workbook
	A	B	C
2		Data	Description
3		8%	Annual Interest Rate
4		10	Number of Months of Payments
5		10000	Amount Loaned
6
7	Result A	-1,037.03
8
9
10
11		6%	Annual Interest Rate
12		18	Years you plan on saving
13		50,000	Amount you want ot have saved in 18 years time
14
15	Result	-129.08
PMT Formula