You can combine cells in Excel, without CONCATENATE function. I think I am over-thinking this it is probably really simple to make an IF formula that handles this whole situation.Good news, if you’re spelling challenged - or too lazy to type long words.
#How to link cells in excel if then full
IF you have not paid your full amount you have a running balance due of (Rent amount minus payments made added to arrears AND Including Late Fees of no more than $50 for a given month IF you have LATE FEES you Should fall between $10,800 and $11,400 IF you paid on time every month You have a ZERO BALANCE **We will use the rent amount for this case as $900 a month**
#How to link cells in excel if then plus
If you Paid your rent every month, but had any late fees the total should be between the normal rent multiplied by 12 months and the normal rent plus up to but not more than $600 in late fees at only $50 a month x 12 month for a late fee total amount you paid should be between $10,800 but not more than $11,400 for the year. If you paid your rent every month on time than the total of your monthly rent multiplied by twelve months a year you will have a ZERO balance, Given the basic run down of things, I need an IF formula that allows me to calculate the following things in ROW 29 ARREARS OWED:(in COLUMN N) SO now on to the real problem I am facing. **NOW, I have lost all confidence in my ability to make a working IF Function** Row 27 will be a slightly higher amount than ROW 23 if the tenant had a late fee included in any given month *Rows 23-27 all have the same formula just their Beginning letter is changed to match their row to give the totals for each row with the same basic formula.* That formula is =SUM(B23:M23) *Back to feeling confident again* So here we are at Column N now, Here we have the basic formula for Adding all the monthly rent totals together to get our grand total. (More reference names of rows, ROW 23:RENT AMOUNT DUE, ROW 24: SUBSIDY, ROW 25: TENANT PORTION, ROW 26: LATE FEE ROW 27:RENTAL INCOME) So moving on.We are now gonna jump back to the top section *Still ok-ish, getting scared that I'm gonna screw up my formulas at this point* Looks like this now for March: =IF(SUM(D36-D38> 0), 0, +C39) and so on through the rest of the months. So in moving forward through the months I would only change the letter in the column/cell B-M to match the Months I am adding and Add the cell before to the end. Which I understood to mean this: If the total amount in C36 minus the amount is C38 is less than $0 add $0, If the amount in C36 is more than $0 add total from B39 are located) In Cell C which is February Cell at the very bottom I have this formula there: =IF(SUM(C36-C38> 0),0,+B39) So, now in the secondary set (where the tenants who pay x amount on x date and x amount on other date and so on. (I'm thinking to myself at this point I'm getting good at this. *Still, so far so good, This is still working. (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: