(Just for a note, This extra rows & columns are like 2 skipped lines beneath the Main Tenant Records as not to interfere with the tenants who actually pay their rent on time in full) so for that I used these basic formulas =SUM(B29-B32), =SUM(B33-B35), =SUM(B36-B38) to account for the amount given vs the balance remaining. I realized I needed to make a few more rows of formulas to account for the tenants that pay their rent in increments as there are only a handful of tenants that pay X amount this week, X amount 2 weeks later and so on. I am using this formula to keep a running total of Any rent that is past due: =SUM(IF(B21-B20>5, 50, 0))+B28 Where "+B28" is the Balance due for JANUARY, so in column C I have this formula: =SUM(IF(C21-C20>5, 50, 0))+C28+B29 Which translates to JANUARY balance plus any late fee or balance in FEBRUARY (so the "+B29" on the end just says don't forget to add last month's left over balance to current total *still so far so good, this is working* I am using this formula for calculating whether or not to add a late fee: =SUM(IF(B21-B20>5, "$50", 0)) Where "B20" is the date due and "B21" is the date paid. I am making a spreadsheet for rent amounts due over the course of one year. Hi, So I have a kind of complicated question(More on that in a minute.) PLEASE BEAR WITH MEÄ«ut for context here is the dilemma I am facing:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |