Formula to add amout if paid or "0" if not paid in a specific column.

[fedcco]

I need a formula that will add the late fee amount from column "J" to column "L" if "Paid" is typed on column "K" or $0 in column "L" if "Owed" is typed in column "K". I also need the same function to happen to column "N" if "Paid or Owed" is typed in column "M". Your input will be greatly appreciated.

Mo.

Rental Amount

Pmt. Meth

Pmt. Meth. Comments

Due Date

Date Tenant Paid

Mgmt. Fees Coll'd.

Repairs Amt.

Repairs Chk. No.

Late Fee Amt.

Paid or Owed

Late Fee 2 RCR

Paid or Owed

Late Fee 2 Owner

Bal. Due Owner

Date Paid to Owner

Pmt. Meth

RCR Chk. No.

Pmt. Meth. Comments

Jan

$1,200

1/1/19

1/4/19

$50

Paid

$50

$0

$1,200

Feb

$1,300

2/1/19

2/7/19

$80

Owed

$80

$0

$1,300

Mar

$1,400

3/1/19

3/11/19

$120

$0

$120

$1,520

Apr

4/1/19

$0

$0

$0

$0

<colgroup><col width="31" style="width: 23pt; mso-width-source: userset; mso-width-alt: 1133;"> <col width="52" style="width: 39pt; mso-width-source: userset; mso-width-alt: 1901;"> <col width="39" style="width: 29pt; mso-width-source: userset; mso-width-alt: 1426;"> <col width="100" style="width: 75pt; mso-width-source: userset; mso-width-alt: 3657;"> <col width="52" style="width: 39pt; mso-width-source: userset; mso-width-alt: 1901;" span="2"> <col width="46" style="width: 35pt; mso-width-source: userset; mso-width-alt: 1682;"> <col width="48" style="width: 36pt; mso-width-source: userset; mso-width-alt: 1755;"> <col width="54" style="width: 41pt; mso-width-source: userset; mso-width-alt: 1974;"> <col width="40" style="width: 30pt; mso-width-source: userset; mso-width-alt: 1462;" span="2"> <col width="37" style="width: 28pt; mso-width-source: userset; mso-width-alt: 1353;" span="2"> <col width="44" style="width: 33pt; mso-width-source: userset; mso-width-alt: 1609;"> <col width="62" style="width: 47pt; mso-width-source: userset; mso-width-alt: 2267;"> <col width="52" style="width: 39pt; mso-width-source: userset; mso-width-alt: 1901;"> <col width="39" style="width: 29pt; mso-width-source: userset; mso-width-alt: 1426;"> <col width="42" style="width: 32pt; mso-width-source: userset; mso-width-alt: 1536;"> <col width="100" style="width: 75pt; mso-width-source: userset; mso-width-alt: 3657;"> <tbody> </tbody>

 

[fedcco]

So, the question is, is there a formula or formulas that will add the late fee to column "L" if the late fee is paid on or prior to the 9th. like the one you supplied, but will add it to column "N" if it's paid on or after the 10th. of the month based on my most recently supplied information?


The formula that you supplied [=IF(K2="paid",L2,0)] works fine but only for the "L" column but doesn't take into consideration that if the late fee is paid on the 10th. or after, then the amount should go in column "N" or to the owner. I hope this helps you with what I'm needing.

Thanks again "Fluff"

 

[Fluff]

Ok in L2
=IF(AND(K2="Paid",DAY(F2)<10),J2,0)
and in N2
=IF(AND(K2="Paid",DAY(F2)>=10),J2,0)

 

[fedcco]

"Perfection". Great job "Fluff" thank you again for putting up with me.

 

[Fluff]

Glad to help & thanks for the feedback