¥»©«³Ì«á¥Ñ av8d ©ó 2011-10-3 08:36 ½s¿è
=IF(AND(M6="A",K6="B"),IF(AND(M6="A",K6="D"),800,IF(AND(L6="E",K6="C"),2000,IF(K6="C",1500,IF(K6="B",1200,IF(K6="D",600,IF(K6="F",1000,IF(K6="G",1000,IF(K6="H",500,""))))))))
§Ú¨Ï¥Îªº¬O2010ªºOFFICE~¤£¬O»¡¥i¥HIF¥i¥H¶W¹L7¼h¶Ü?¦ý¬O«o¥X²{"µLªk¿é¤J«ü©wªº¤½¦¡¡A¦]¬°¥L¨Ï¥Î¶W¹L¥Ø«eÀɮ׮榡©Ò¤¹³\ªº±_ª¬¼h¯Å¼Æ¶q¡C" |