If Then program i think

[carrguy01]

I have a amortization schedule running and i want to recod the last payment number into a specfic cell. This is hard to explain but here it goes

Installment #______<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o> </o>
<o> </o>
Installment monthly payment interest lump sum payment current balance <o></o>
1 1526.83 852.308 674.75 249325.25 <o></o>
2 1526.83 849.78 677.05 248648.20<o></o>
3 1526.83 847.48 679.36 248500 0

I need to have the instalment number 3 to auto fill at the top of the page. I am not sure how to do that as current balance column has formulas in it.

 

[Richard Schollar]

Hi

Could you just use

=MAX(Installment_Column)

?

 

[carrguy01]

I have no idea how to use that formula

 

[Richard Schollar]

Well, assuming your first column is Installment (say in A2:A100) then you would use:

=MAX(A2:A100)