Cột F:
=IFNA(IF(J14="SAMPLE",CONCATENATE("GIAO SAMPLE CHO PD"," ",H14," ","lịch in:",TEXT(AD14,"DD-MMM")),IF(AD14="Wait RM",CONCATENATE(H14," ",J14," "," ","VT"," ",D14
,"Met","/ ","MO Release date: ",TEXT($O$4,"DD-MMM"&" "&"h:mmAM/PM")),CONCATENATE(H14," ",J14," "," ","VT"," ",D14,"Met"," ",,"/ ",
MO Release date: ",TEXT($O$4,"DD-MMM"&" "&"h:mmAM/PM"),"/ ","Printing date:"," ",TEXT(AD14,"DD-MMM")))),CONCATENATE(H14," ",J14," "," ","VT"," ",D14,"Met"," /","MO Release date: ",TEXT($O$4,"DD-MMM"&" "&"h:mmAM/PM")," /","Printing date:"," ",TEXT(AD14,"DD-MMM""")))
Cột T:
=(IF(RIGHT(P14,3)="SET",((Y14/1000*AA14)+((K14+AM14)*(Y14/1000*AA14))+(AI14*AB14*Y14/1000))*2,IF(LEFT(P14,3)="ROY",((Y14/1000*AA14)+
((K14+AM14)*(Y14/1000*AA14))+(AI14*AB14*Y14/1000))*1.5,IF(LEFT(P14,13)="163178-6Pages",((Y14/1000*(AA14/2))+((K14+AM14)*(Y14/1000*
(AA14/2)))+(AI14*AB14*Y14/1000))+(((Y14/2)/1000*(AA14/2))+((K14+AM14)*((Y14/2)/1000*(AA14/2)))+(AI14*AB14*(Y14/2)/1000)),IF(P14="188658_14
pages_recycle",((Y14/1000*AA14)+((K14+AM14)*(Y14/1000*AA14))+(AI14*AB14*Y14/1000))*0.88,IF(P14="188658_10 pages_recycle",((Y14/1000*AA14)
+((K14+AM14)*(Y14/1000*AA14))+(AI14*AB14*Y14/1000))*0.83,IF(P14="188658_6 pages_recycle",((Y14/1000*AA14)+((K14+AM14)*(Y14/1000*AA14))
+(AI14*AB14*Y14/1000))*0.75,IF(P14="188659_6pages_recycle",((Y14/1000*AA14)+((K14+AM14)*(Y14/1000*AA14))+
(AI14*AB14*Y14/1000))*0.75,IF(P14="188659_10 pages_recycled",((Y14/1000*AA14)+((K14+AM14)*(Y14/1000*AA14))
+(AI14*AB14*Y14/1000))*0.83,(Y14/1000*AA14)+((K14+AM14)*(Y14/1000*AA14))+(AI14*AB14*Y14/1000))))))))))
Cột U:
=IF(OR(O14="F051003009",O14="F051003300",O14="F051002952",O14="F051002953",O14="F051003091",O14="F051004127",O14="F051004128",
O14="F051004129",O14="F051004574",O14="F051004573",O14="F051004575"),400+AB14*3,IF(OR(O14="F051004153",O14="f051000442",
O14="F051002340",O14="f051000454",O14="f051000470",O14="f051000509",O14="f051000442",O14="f051001680",O14="f051001881",
O14="f051001882",O14="f051001921",O14="F051002340",O14="F051002599",O14="F051003262",O14="F051003593",O14="F051004153",
O14="F051004198"),200+AB14*3,IF(OR(O14="F051002884",O14="F051002885",O14="F051002882",O14="F051002895",O14="F051002907",
O14="F051002912",O14="F051002911",O14="F051002933",O14="F051002946",O14="F051002964",O14="F051002966",O14="F051002969",
O14="F051002967",O14="F051003018",O14="F051003036",O14="F051003107",O14="F051003108",O14="F051003143",O14="F051003147",
O14="F051003148",O14="F051003149",O14="F051003185",O14="F051003149",O14="F051003267",O14="F051003270",O14="F051003268",
O14="F051003269",O14="F051003340",O14="F051003412",O14="F051003417",O14="F051003415",O14="F051003491",O14="F051003526",
O14="F051003545",O14="F051003560",O14="F051003599",O14="F051003598",O14="F051003643",O14="F051002883",O14="F051003735",
O14="F051003750",O14="F051003768",O14="F051003771",O14="F051003796",O14="F051003877",O14="F051004435",O14="F051004458"),
145,IF(J14="sample","200",30+AB14*3))))