Results 1 to 4 of 4

Need formula to zero payment amount made if month changed

Threaded View

  1. #1
    Registered User
    Join Date
    02-12-2010
    Location
    Toms River, NJ
    MS-Off Ver
    Excel 2010
    Posts
    42

    Need formula to zero payment amount made if month changed

    I'm still working on my financial spreadsheet. I have a page in the spreadsheet where I have the date a bill was last paid and the amount of the last payment.

    Column C=Amount of the bill
    Column D=Bill Due Date
    Column E=Last date paid
    Column G=Amount Paid This Month
    Column H=Due Date
    Column I=Amount Still Due this month

    See attached example
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1