I am trying to get Cells Q,S,U,W,Y,AA & AC (in the example photo) to read "PAID" or "DUE" based on information from other cells.
I have been able to get it all to work except 1 issue...... I want the "PAID" to show if the balance is equal or over cell "K" no matter if the cell beside it is blank or not. I want the "DUE" to not show at all if the payment cell beside it is empty.
This is the argument I have: I just need to get the "PAID" to show in cell "S".
In this example, the formula that is in "S" is:
=IF(R6="","",IF(OR($K$6<=0,$K$6=""),"",IF($K$6>=R3,"PAID",IF(OR($K$6<=R3,$K$6>0),"DUE",""))))
the formula that is in U,W,Y,AA & AC is:
=IF(OR($K$6<=0,$K$6=""),"",IF($K$6>=T3,"PAID",IF(OR($K$6<=T3,$K$6>0),"DUE","")))
Thank you,
Bookmarks