Date Tenant Paid | Mgmt. Fees Col'd. | Repairs Amt. | Repairs Chk. No. | Late Fee Col'd. | Late Fee RCR | Late Fee Owner | Bal. Due Owner |
03/13/19 | 140 | 140 | 140.00 | ||||
0 | 0.00 |
I do not understand this. This does not make sense. How can the amount in cell J6 get the amount from another formula in J6?Late fee Col'd is J6 Which gets the amount from another formula in J6
| A1 | B1 | C1 | D1 | E1 | F1 | G1 | H1 | I1 | J1 | K1 | L1 |
| Mo. | Rental Amount | Pmt. Meth | Pmt. Meth. Comments | Due Date | Date Tenant Paid | Mgmt. Fees Coll'd. | Repairs Amt. | Repairs Chk. No. | Late Fee Coll'd. | Late Fee RCR | Late Fee Owner |
6 | Jan | $1,200 | Cash | | 01/01/19 | 01/12/19 | $100 | $55.12 | | $130 | FALSE | $130 |
7 | Feb | $1,200 | | | 02/01/19 | 02/07/19 | $100 | | | $80 | $80 | FALSE |
8 | Mar | $1,200 | | | 03/01/19 | 03/02/19 | $100 | | | $0 | $0 | FALSE |
9 | Apr | $1,200 | | | 04/01/19 | 04/05/19 | $100 | | | $60 | $60 | FALSE |
Book1 | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | |||
5 | Mo. | Rental Amount | Pmt. Meth | Pmt. Meth. Comments | Due Date | Date Tenant Paid | Mgmt. Fees Coll'd. | Repairs Amt. | Repairs Chk. No. | Late Fee Coll'd. | Late Fee RCR | Late Fee Owner | ||
6 | Jan | $1,200 | Cash | 1/1/2019 | 1/12/2019 | $100 | $55.12 | $130 | $0 | $130 | ||||
7 | Feb | $1,200 | 2/1/2019 | 2/7/2019 | $100 | $80 | $80 | $0 | ||||||
8 | Mar | $1,200 | 3/1/2019 | 3/2/2019 | $100 | $0 | $0 | $0 | ||||||
9 | Apr | $1,200 | 4/1/2019 | 4/5/2019 | $100 | $60 | $60 | $0 | ||||||
Sheet571 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
K6 | =IF(J6<=100,J6,0) | |
L6 | =IF(J6>100,J6,0) |