Sum but stop off date

pworth@jacksonprop.com

hello smarties... i need to create a formula so that the interest due stops on a payment date

Currently i have the following formula in the Interest Due column...

=SUM([Future Charges]@row + [Amount placed]@row * [Interest Percent]@row * [# of Months]@row) / 12

I need to add that it needs to stop on the Payment Date

thank you

dates.PNG

Jason Albrecht

Hey there,

It looks like this is similar to an amortization schedule, where the function IPMT() may be useful?