รบกวนดูให้หน่อยครับ สูตรชุดนี้ผิดตรงไหนครับ
Posted: Fri May 13, 2016 12:21 pm
=IF(And(or(G11>0,G11="-"),H11>0,I11>0,J11>0,W11>0,X11>0),"Done",
IF(And(or(G11>0,G11="-"),H11>0,I11>0,J11>0,W11>0,X11=""),"Wait for submit to CSO",
IF(And(or(G11>0,G11="-"),H11>0,I11>0,J11>0,W11="",X11=""),"Wait for Open Tax",
IF(And(or(G11>0,G11="-"),H11>0,I11>0,J11="",W11="",X11=""),"Handover to customer",
IF(And(or(G11>0,G11="-"),H11>0,I11="",J11="",W11="",X11=""),"Wait for submit to customer",
IF(And(or(G11>0,G11="-"),H11="",I11="",J11="",W11="",X11=""),"Wait for Prepare DAC",
IF(And(G11="",H11="",I11="",J11="",W11="",X11=""),"In Delivery process","AAAAAA")
IF(And(or(G11>0,G11="-"),H11>0,I11>0,J11>0,W11>0,X11=""),"Wait for submit to CSO",
IF(And(or(G11>0,G11="-"),H11>0,I11>0,J11>0,W11="",X11=""),"Wait for Open Tax",
IF(And(or(G11>0,G11="-"),H11>0,I11>0,J11="",W11="",X11=""),"Handover to customer",
IF(And(or(G11>0,G11="-"),H11>0,I11="",J11="",W11="",X11=""),"Wait for submit to customer",
IF(And(or(G11>0,G11="-"),H11="",I11="",J11="",W11="",X11=""),"Wait for Prepare DAC",
IF(And(G11="",H11="",I11="",J11="",W11="",X11=""),"In Delivery process","AAAAAA")
วงเล็บปิดครับ