payments

woodier · Mar 2nd, 2002, 12:42 PM

I need help with writing a formula that includes a recurring monthly charge, a daily late charge (with grace period), payments made on various dates, and the balance on the payment date. One may use any recurring monthly charge amount, any daily late charge amount, any constant number of grace period days, and any assortment of payment dates, that they desire. Your assistance will be greatly apprecitated.

[ This Message was edited by: woodier on 2002-03-02 17:57 ]

Anne Troy · Mar 2nd, 2002, 02:22 PM

What is the recurring monthly charge or what cell will it be stored in?

How much is the daily late charge after the grace period or what cell is that stored in?

How many days until a late charged is incurred (including grace period) or what cell is this amount stored in?

How much are the various payments or what cell(s) are they stored in?

What is the payment date or what cell is it stored in?

We cannot guess what you are trying to do and the variables you're using. The more information you provide, the better we can respond.

I often believe it is best to give us the exact (or sample) location of your data.

Mar 2nd, 2002, 02:22 PM	#2
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,512	What is the recurring monthly charge or what cell will it be stored in? How much is the daily late charge after the grace period or what cell is that stored in? How many days until a late charged is incurred (including grace period) or what cell is this amount stored in? How much are the various payments or what cell(s) are they stored in? What is the payment date or what cell is it stored in? We cannot guess what you are trying to do and the variables you're using. The more information you provide, the better we can respond. I often believe it is best to give us the exact (or sample) location of your data. __________________ ~Anne Troy

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 2nd, 2002, 12:42 PM	#1
woodier New Member Join Date: Feb 2002 Posts: 8	I need help with writing a formula that includes a recurring monthly charge, a daily late charge (with grace period), payments made on various dates, and the balance on the payment date. One may use any recurring monthly charge amount, any daily late charge amount, any constant number of grace period days, and any assortment of payment dates, that they desire. Your assistance will be greatly apprecitated. [ This Message was edited by: woodier on 2002-03-02 17:57 ]