Sum but stop off date

pworth@jacksonprop.com · 08/11/21

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

Jason Albrecht · 08/12/21

Hey there,

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

Answers