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

av8d

=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"

Hsieh

¦^´_ 6# av8d


    §A¦³¬Ý³£¨S¦³À´
¨º§Ú¨S¬Ý§ó¤£·|À´

av8d

¦^´_ 4# Hsieh


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

GBKEE

¦^´_ 4# Hsieh
¾Ç²ß¤F

Hsieh

¦^´_ 3# GBKEE


    ¦]¬°2010ª©¥»¬°32¼h­­¨î
·í¥H2010ª©¥»¦s¦¨97-2003¬¡­¶Ã¯¡AªþÀɦW¬°xls¡A¥i¯à³Q§P©w¶W¥X7¼h­­¨î¦Ó¤£¬Û®e
¥²¶·¥H°ÆÀɦW¬°xlsx¦sÀÉ¡A¨Ã¥H2007¥H¤Wª©¥»¶}±Ò¤~¯à¶W¥X7¼hªº­­¨î

GBKEE

¦^´_ 2# Hsieh
  =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(A1=1,A2,B2)
A2=IF(A1=2,B3,C3)
B2=IF(A1=3,B4,C4) ....... ->  ·|¤£¤î7¼hªº

=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,""))))))))  ¦h¤F¤@¼h

Hsieh

¦^´_ 1# av8d


  ¥i¯à¦]¬°§AªºÀÉ®×Ãþ«¬¬Oxls
¥t¦s¦¨xlsx¸Õ¸Õ¬Ý