Snasui Excel Forum

Hi Dear
I come up with this issue
if column A-D are blank the status is No Due
if submission date is current month status is No due
if submission date is current month and Total >0 status is received-claim
if C/N No is not blank status is processed
I also try
=IF(OR(COUNTA(A2:D2)=4,MONTH(A2)=MONTH(TODAY())),"No Due",IF(OR(AND(E2>0,MONTH(A2)=MONTH(TODAY())),F2=""),"received","Processsed")) but no luck

I attached a template


Best wishes

Please provide correct result for comparing the answers.

I think the formula in G2 is

=IF(COUNTBLANK(A2:D2)=4,"No Due",IF(MONTH(A2)=MONTH(TODAY()),"No Due",IF(AND(MONTH(A2)=MONTH(TODAY()),E2>0),"Receive-Claim",IF(F2<>"","Processed","Not meet condition"))))

Press enter and copy down.

thanks