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

[µo°Ý] ½Ð°Ý¸Ó¦p¦ó¤U¤½¦¡

[µo°Ý] ½Ð°Ý¸Ó¦p¦ó¤U¤½¦¡

½Ð°Ý¡G§Ú¦bC8©MB8¤â°Ê¿é¤J¸ê®Æ¡A¦bE9¡BG9¡BI9¡BK9¡BL9¡BM9¡BN9¡BO9­n«ç»ò¤U¤½¦¡¡A¨Ì¾Ú²Ä¤G­¶ªº¸ê®Æ¡A¦Û°Ê¶]¥X¼Æ¾Ú¨Ó©O???



¦p¦ó¤U¤½¦¡.rar (6.28 KB)

¦^´_ 12# yangjie

¦¹¨Ò·íµM¥i¥H±N2¨ú¥N¦¨1
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¥»©«³Ì«á¥Ñ yangjie ©ó 2010-11-15 17:19 ½s¿è

¦^´_ 9# Hsieh


     ÁÂÁÂHsieh¤j¤j«ü¾É
   §¹¥þ¤F¸Ñ
            =LOOKUP(2,1/((²Ä¤G­¶!$A$1:$A$27=ªí®æ!$C8)*(²Ä¤G­¶!$B$1:$B$27=ªí®æ!$D8)),²Ä¤G­¶!C$1:C$27)
   «Ü´ÎªºÅÞ¿è·Qªk  ¨ü±Ð¤F
  2  ¤]¥i¥H¥Î 1 ¨ú¥NÅo  
   ¦]¬°1>=1/1   
    ¨º»ò ¥Î2 ¥Î1 ¦bÅÞ¿è¤W¦³¦ó®t²§(¦]¬° 1/((²Ä¤G­¶!$A$1:$A$27=ªí®æ!$C8)*(²Ä¤G­¶!$B$1:$B$27=ªí®æ!$D8)=1 ©Î0©ÎDIV/O)
    ¬O§_¦p¦¹

TOP

°Ñ¦Ò¬Ý¬Ý

¦p¦ó¤U¤½¦¡.rar (9.45 KB)

ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

¦^´_ 7# gong


    ¥i¥H¤ñ¸ûªº¸Ü¡A·íµM¬O³Ì¦nªº¤F¡A³o¼Ë´N¤£¥Î¨C¦¸³£¥h®Ö¹ï¸ÕÅ窺µ²ªG¬O¤£¬O¦b³W½d­È¸Ì¡C
     ½Ð±Ðgong¤j¤j¡A¦pªG­n¯à°÷¤ñ¸ûªº¸Ü¡A²Ä¤G­¶ªº¬[ºc¸Ó¦p¦ó°µ­×§ï©O???
    °²¦p­×§ï§¹«á¡A¤½¦¡¬O¤£¬O­n¦b°µ­×§ï©O??

TOP

¥»©«³Ì«á¥Ñ Hsieh ©ó 2010-11-14 22:38 ½s¿è

1/((²Ä¤G­¶!$A$1:$A$27=ªí®æ!$C8)*(²Ä¤G­¶!$B$1:$B$27=ªí®æ!$D8))³o·|²£¥Í¤@¦ê1»P¿ù»~­Èªº¼Æ¦C
­Y²Ä¤G­¶!A1=ªí®æ!$C8¦Ó¥B²Ä¤G­¶!B1=ªí®æ!$D8¨º·|±o¨ìTRUE*TRUE=TRUE©Ò¥H´N¦¨¤F1*1=1    ---------->1/1=1
­Y²Ä¤G­¶!A2=ªí®æ!$C8¦ý²Ä¤G­¶!B2<>ªí®æ!$D8¨º·|±o¨ìTRUE*FALSE=TRUE©Ò¥H´N¦¨¤F1*0=0    --------->1/0=#DIV/0!
­Y²Ä¤G­¶!A3<>ªí®æ!$C8¦ý²Ä¤G­¶!B3=ªí®æ!$D8¨º·|±o¨ìFALSE*TRUE=FALSE©Ò¥H´N¦¨¤F0*1=0  --------->1/0=#DIV/0!
­Y²Ä¤G­¶!A4<>ªí®æ!$C8¦Ó¥B²Ä¤G­¶!B4=ªí®æ!$D8¨º·|±o¨ìFALSE*FALSE=FALSE©Ò¥H´N¦¨¤F0*0=0  --------->1/0=#DIV/0!
2¬O¦b¸Ó¼Æ¦C·j´M¤p©óµ¥©ó2ªº¦ì¸m
¾ãÅé¶Ç¦^¹ïÀ³²Ä¤G­¶!C$1:C$27ªº¦ì¸m
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¥»©«³Ì«á¥Ñ yangjie ©ó 2010-11-14 00:47 ½s¿è

¦^´_ 3# oobird


    ½Ð±Ðoobird¤j¤j
         =LOOKUP(2,1/((²Ä¤G­¶!$A$1:$A$27=ªí®æ!$C8)*(²Ä¤G­¶!$B$1:$B$27=ªí®æ!$D8)),²Ä¤G­¶!C$1:C$27)
   §Ú¹ï¦¹¤½¦¡«Ü·P¿³½ì»PºÃ´b  ½Ð«ü¾É
   «e­±ªº 2,1¬O«ü¨â­Ó±ø¥ó¶Ü
          /¬O«ü   ¤U¦Cªº½d³ò  ¶Ü

TOP

oobird ª©¥D¬O§_¦X¥Î
¾É¤Jªº¬O¤å¦r,µLªk¤ñ¹ï¬O§_¦X¥G³W½d¤º
¦p¥u­n¾É¤J, oobird ª©¥D§Y¥i
­n¤ñ¸û­n§ï²Ä¤G­¶¬[ºc
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

¦^´_ 5# gong



    E8:N8ªº¸ê®Æ¡A¬O¸g¥Ñ¹êÅç©Ò±o¨ìªº¼Æ¾Ú¡A¤À§O¿é¤J¨ì¸Ì­±ªº¡A¦Ü©óE9:O9«h¬O³W½d­È¡A³W½d­È«h¬O¥þ³¡¿é¤J¦b²Ä¤G­¶¸Ì¤F¡A·QÂǥѦbC8©MD8³o2®æ¿é¤J¤§­È¡A¥h§PÂ_²Å¦XC8©MD8³o2­Ó­Èªº¼Æ¾Ú¡A¤À§O¦Û°Ê¶ñ¤JE9¡BG9¡BI9¡BK9¡BL9¡BM9¡BN9¡BO9³o´X­ÓÀx¦s®æ¸Ì¡C



¦Ü©ó±z»¡ªºªíÀY¡A¬O³o­Ó¶Ü???§Ñ°O¿é¤J¡K©êºp

TOP

½Ð°Ýe8:n8¸ê®Æ¦p¦ó¨ú±oªº
¬O¨Ì¾Úc8¶Ü,ÁÙ¬O...

­n¶ñ¤Je99¶ñ¤J¤°»ò¸ê®Æ
²Ä¤G­¶³sªíÀY³£¨S¦³¦p¦ó¹ï·Ó
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

        ÀR«ä¦Û¦b : ­n¥Î¤ß¡A¤£­n¾Þ¤ß¡B·Ð¤ß¡C
ªð¦^¦Cªí ¤W¤@¥DÃD