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

¹B¶O­pºâ¤½¦¡

¹B¶O­pºâ¤½¦¡

¥»©«³Ì«á¥Ñ sandy ©ó 2012-1-12 00:46 ½s¿è

¦pªG¥ó¼Æ¥N¸¹¬O6¡A­«¶q¬O10®É¡G¥»´Ú°_½Xª÷ÃB=95
¦pªG¥ó¼Æ¥N¸¹¬O6¡A­«¶q¬O20®É¡G¥»´Ú°_½Xª÷ÃB=120
¦pªG¥ó¼Æ¥N¸¹¬O6¡A­«¶q¬O30®É¡G¥»´Ú°_½Xª÷ÃB=145
¦pªG¥ó¼Æ¥N¸¹¬O8¡A­«¶q100©Î100¥H¤W¡A¨ìµÛ¯¸¬O¥_¥«¡B¦Á¤î¡B¥_§ë¡B¤T­«¡B¤­ªÑ¡B¤g«°¡B¤¤©M¡B·s©±¡B²`§|®É¡G¦Ê¤½¤ç¥»´Ú=65
¦pªG¥ó¼Æ¥N¸¹¬O8¡A­«¶q100©Î100¥H¤W¡A¨ìµÛ¯¸¬O°ò¶©®É¡G¦Ê¤½¤ç¥»´Ú=95
¦pªG¥ó¼Æ¥N¸¹¬O8¡A­«¶q100¥H¤U¡A¨ìµÛ¯¸¬O°ò¶©®É¡G¥¼¹F¦Ê¤½¤ç®É¤§¥»´Ú=61
¨ä¥L­p¶O¼Ð·Ç¦bªþ¥ó¸Ì.
§Ú§Æ±æ¦b¸Õºâªí¸Ì¶K¤W³f¹B¤½¥qªº¹ï±b¸ê®Æ«á¥iÅçºâ¬O§_¥¿½T.
¹B¶O­pºâªí.rar (232.53 KB)
¤£ª¾¹D­n«ç»ò³]¤½¦¡?
·Ð½Ð°ª¤â«ü¾É.ÁÂÁÂ!
SANDY

¦^´_ 1# sandy

O3=IF(A3=TEXT(6,0),"",IF(A3=TEXT(8,0),INDEX(­p¶O¼Ð·Çªí!$C$2:$C$246,MATCH("*"&D3&"*",­p¶O¼Ð·Çªí!$A$2:$A$246,0)+6),""))
P3=IF(A3=TEXT(6,0),LOOKUP(G3,{10,20,30},{95,120,145}),IF(A3=TEXT(8,0),VLOOKUP("*"&D3&"*",­p¶O¼Ð·Çªí!$A:$C,3,0),""))
Q3=IF((G3)<100,P3,(O3*(G3/100)))

TOP

¦^´_ 2# register313


    °£¤F¨ì¥Iªº¦a¤è¨S¦³¸ê®Æ¥~¨ä¥L³£¦³¸ê®Æ
   ¤£¹LªþÀɤ¤"¸Õºâªí"ªº¤u§@ªíªº¨ì¯¸³B§t¦³ªÅ¥Õ
   ·|³y¦¨¤½¦¡¿ù»~¡A¤£ª¾¹D¼Ó¥D¦³¨S¦³µo²{
   
   ¥H«e´N¦n©_´M§ä­Èªº³¡¥÷¥i¤£¥i¥H¥Î"*"ªº¤è¦¡·j´M
   ²{¦b¬Ý¨ì¤S¦h¾Ç¤@¦U
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

TOP

¦^´_ 2# register313


    :P ¶W·P°Êªº­C..©~µM¦³¤H¦^§Ú¤F!·PÁ·PÁÂ!
§Úµ¥¤@¤U¥h¸Õ¸Õ¬Ý³á!
SANDY

TOP

¦^´_ 3# freeffly


    ÁÂÁ±z´£¿ô
ªº½T¦³«Ü¦hªÅ¥Õ³B
§Úµ¥¤@¤U³B²z
­YÁÙ¦³°ÝÃD.¦A¦V¦U¦ì°Q±Ð.·PÁ§A­Ì!:)
SANDY

TOP

¦^´_ 2# register313


    register313 ¤j®v:
·PÁ±zªº¤½¦¡..¯uªºok¤F­C!
¸Ñ¨M¤F§Úªº¤j§xÂZ.¯u¬O¤Ó·P¿E¤F!
SANDY

TOP

¦^´_ 3# freeffly


    ·PÁ±z´£¿ôªÅ¥Õ³B.§Ú¤w¥þ³¡¨ú¥N±¼.¨S¥X²{¿ù»~¥N½X¤F.ÁÂÁÂ!
SANDY

TOP

        ÀR«ä¦Û¦b : ¡i°µ¤Hªº¶}©l¡j¨C¤@¤Ñ³£¬O¬G¤Hªº¶}©l¡A¨C¤@­Ó®É¨è³£¬O¦Û¤vªºÄµ±§¡C
ªð¦^¦Cªí ¤W¤@¥DÃD