Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: payments

  1. #1
    New Member
    Join Date
    Feb 2002
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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 ]

  2. #2
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Westwood NJ
    Posts
    2,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •