ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] ¨Ï¥Î¶W¹L¥Ø«eÀɮ׮榡©Ò¤¹³\ªº±_ª¬¼h¯Å¼Æ¶q¡C(¤w¸Ñ¨M¡A·PÁ¨â¦ì¤j¤j)

[µo°Ý] ¨Ï¥Î¶W¹L¥Ø«eÀɮ׮榡©Ò¤¹³\ªº±_ª¬¼h¯Å¼Æ¶q¡C(¤w¸Ñ¨M¡A·PÁ¨â¦ì¤j¤j)

¥»©«³Ì«á¥Ñ 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"

¦^´_ 4# Hsieh


    ¦s¦¨xlsxµLªk¨Ï¥Îµ{¦¡ªº¼Ë¤l~¥L¦³½Ð§Ú­×§ï~¥i¬O¦³¬Ý¨S¦³À´!

TOP

        ÀR«ä¦Û¦b : ¹ï¤÷¥À­nª¾®¦¡A·P®¦¡B³ø®¦¡C
ªð¦^¦Cªí ¤W¤@¥DÃD