Help To Automate the Comment Row with an If statement.

DUMELANG,
The statement has 4 conditions but a pair each has same vector, the only way to differentiate them is through a cell which is K79 for PWT(Paid Within Target
) & POT (PAID OFF TARGET) shouldn't be blank.

While K79 for NPWT(Not Paid Within Target) & NPOT(Not Paid off Target) should be blank.

PWT & NPWT Target is less than 14days..
POT & NPOT Target id more than 14days...

I have tried my best to make this formula to respond to all situations but it doesn't respond:

IF((ISNUMBER(K79),K79<=14,""),"PWT",IF(AND(D79-$F$76<=14,K79=""),"NPWT",IF((ISNUMBER(K79),K79>14,"")"POT",IF(AND(D79-$F$76>14,K79=""),"NPOT"))))

Hi Khali, try the following formula in Cell L16 and copy down (only in your sample book - references need to change for your real book).

Please Login or Register  to view this content.