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

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

¦^´_ 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

TOP

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

TOP

        ÀR«ä¦Û¦b : ¤Hªº¤ß¦a¬O¤@²¥¥Ð¡A¤g¦a¨S¦³¼½¤U¦nºØ¤l¡A¤]ªø¤£¥X¦nªºªG¹ê¡C -
ªð¦^¦Cªí ¤W¤@¥DÃD