ªð¦^¦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)

±z¥u­n¦b¦sÀx®æ¤º¿é¤J

=sum(c8,b8)

µM«á¬Ý±zªº¹Bºâ¬O­n¥[©Î´î´N¥i¥H¤F¡A¥¦´N·|¦Û¤v¥h¹Bºâ¤F
¤£ª¾¹D³o¼Ë¦æ¤£¦æªº³q
½Ð±z¦b¸Õ¸Õ¬Ý~~^^

TOP

ªí®æ³o¼Ë°µ¬O¦Û§ä³Â·Ð¡C
¦p¦ó¤U¤½¦¡.rar (6.63 KB)

TOP

¦^´_ 3# oobird

·PÁ¤j¤jªº»¡©ú¡A·|³o»ò°µ³o­Óªí®æ¡A¬O¦]¬°³o­Óªí®æ¥»¨Ó¬O¥Î¦bwordªº¡A¥Î¦bword®É¨C¦¸³£­n¨Ì·ÓºÙ¸¹©MÃþ§Oªº¤£¦P¡A¥h¿ï¾Ü¥¦ªº³W½d­È¡AµM«á¦b¶K¤W¥h

§Ú¬O§â¨Ì·Ówordªº®æ¦¡¡A§â¥LÂনexcelªº¡A¦Ó¥B¸Ó®æ¦¡¤£¯à°µ¤Ó¤jªºÅÜ°Ê¡A¦b¤U¥u¯à·Q¨ì³o¼Ëªº¤è¦¡¡A¤£ª¾¹D¤j¤j¦³§ó¦nªº¤èªk¶Ü???

TOP

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

­n¶ñ¤Je99¶ñ¤J¤°»ò¸ê®Æ
²Ä¤G­¶³sªíÀY³£¨S¦³¦p¦ó¹ï·Ó
ª¾¤§¬°ª¾¤§¡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

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

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

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

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

        ÀR«ä¦Û¦b : ¤@­Ó¤Hªº§Ö¼Ö¡D¤£¬O¦]¬°¥L¾Ö¦³±o¦h¡A¦Ó¬O¦]¬°¥L­p¸û±o¤Ö¡C
ªð¦^¦Cªí ¤W¤@¥DÃD