Xuân Thanh > 15-05-15, 08:56 PM
(14-05-15, 10:45 PM)maidinhdan Đã viết: Hàm của bạn đây: Mã:=(IF(E4>0,VLOOKUP($E$3,$K$8:$L$10,2,0),0)*E4)+(IF(F4>0,VLOOKUP($F$3,$K$8:$L$10,2,0),0)*F4)+(IF(G4>0,VLOOKUP($G$3,$K$8:$L$10,2,0),0)*G4)
=(IF(E4>0,VLOOKUP($E$3,$K$8:$L$10,2,0),0)*E4)+(IF(F4>0,VLOOKUP($F$3,$K$8:$L$10,2,0),0)*F4)+(IF(G4>0,VLOOKUP($G$3,$K$8:$L$10,2,0),0)*G4)