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

¦V¥k·j´Mªº°ÝÃD½Ð°ª¤âÀ°¦£¸Ñ¨M,ÁÂÁÂ!!

¦V¥k·j´Mªº°ÝÃD½Ð°ª¤âÀ°¦£¸Ñ¨M,ÁÂÁÂ!!

¥»©«³Ì«á¥Ñ oobird ©ó 2011-2-12 20:29 ½s¿è

[attach]4569[/attach]¦]¬°·~ÁZ¼úª÷¤u§@ªí¤¤·j´M°ò¥»¸ê®Æ²£«~¦WºÙ­«½Æ,¦]°â»ù¤£¦P©Ò¥H¥²­n¦b²£«~¦WºÙ«á­±¦h¥[­Ó¦r¥H«K°Ï¤À
¦ý²£«~¤Ó¦h·|³y¦¨²V¶Ã,½Ð°ª¤âÀ°¦£¸Ñ¨M,ÁÂÁÂ!!

²S´I1.rar (20.05 KB)

chaoping22

¦^´_ 1# chaoping22


    Åv­­¤£°÷¡A¨Sªk¤U¸ü«¨!!  ¥i¤£¥i¥H¶K­Ó¹Ï©Î¥´­Ó´X¦æªº¤p½d¨Ò¨Ó¬Ý¬Ý¡C¤£µM¹ï§Ú­Ì³o¨ÇÁÙ¨S¦³Åv­­¤U¸üªº¤H¥u¯à¬Ý¬Ý´N¦n

TOP

¦]¬°¤ñ¸û½ÆÂø,«ÜÃø¥Î¹Ï¤ù©Î¥´´X¦æ¦r´N¯àªí¹F,
¤£¹LÁÙ¬OÁÂÁ§A!!
chaoping22

TOP

¦U¦ì«e½ú,½Ð¨DÀ°¦£¸Ñ¨M,ÁÂÁÂ!!
chaoping22

TOP

ªí¹F±oÁÙ¬O¤£²M·¡
§A­n§¹¦¨ªº¬O­þ­Óªí¨º¤@Ä檺¸ê®Æ¡H

TOP

§Ú­Ó¤Hı±o
excel¶È¾A¦X¼Æ¶q±±ºÞ

¦pªG­n§â°â»ù¤Î¦¨¥»¥[¶i¨Óºâ
«Øij¦A«Ø¥ß¤@­Ó°â»ùªí,¥H§Úªº¸gÅç±`Ãø¦pÄ@
¦]¬°³æ¤@°Ó«~¦³§é¦©¦]¯À,¦³¦þª÷«á°h,¦³§éÅý,¦³·fÃØ,¦³¶R7°e¤@µ¥µ¥,§A·Q¤£¨ìªº¤è®×³£¦³
«ç»ò¬[³£¤£§¹³Æ,¦]¬°¾P°â³]­pª÷ÃB¤£¦b§A¤â¤W,¦pªG¬O,¾P°âÁ`¤£·|¬O§A¤F§a,¾P°â­ì«h´N¬O±ø½X¨ê¤@¨ê´N¦n
¬O³o¼Ë¶Ü?¤]¤£¾¨µM,¦³±ø½X¦L¿ùªº,¦³¦P¤@°Ó«~¤£¦P¼t¥Xªº±ø½X¤]¤£¦P,¨ê¤£¨ì¸ê®Æ

¦pªG§â¼Æ¶q,°â»ù,¦¨¥»¤@°_¨º¶i¨Ó³B²z,¸ê®Æµ§¼Æ¤£¨ì¤@­Ó¤ë´N©ñ¤£¤U¤F
¤£µM´N¬O¶]¤£°Ê,³Ì«áÁÙ¬O¥æµ¹¨t²Î³B²z

ª±ª±¥i¥H,§â¥L·í¤u§@°µ·|¦Y¨¬­WÀY,³Ì«á¥þ³¡¨Ì¿à§AÅܦ¨§A©ß¤£±¼ªº¤u§@
§Ú­Ó¤H¤ß±o

¨¥Âk¥¿¶Ç
1.«Ø¥ß°â»ùªí,¦UºØ±ø¥ó­n³]¦n,­n±M¤H³B²z(¦p¼Æ¶q§é¦©ªí,10§é¦©10%,100§é¦©20%)
2.«Ø¥ß¦¨¥»ªí,¦¨¥»ªí§A·|©ü­Ë,¦]¬°¤µ¤Ñ¶i10¤¸,©ú¤Ñ¥i¯à12¤¸,«á¤Ñ¬°9¤¸¦pªo»ù¯B°Ê
   ¨º«ç»ò¿ì?«Øij³]¤é´Á»ù®æ¦Û°Ê§ì°Ï¶¡¦¨¥»
³o¼Ë´N°÷½ÆÂø¤F

¦pªG«~¶µ¤@¦h­þ¸Ì¶]ªº°Ê

²z·Q«Ü¦n,¦pªG·Q­n¬[ºc¶i¾P¦s,¥i¥H¤@°_¬ã¨s¬Ý¬Ý,§A´£ºc·Q, §Ú­Ì·Q·Q¿ìªk¬O§_¥i¥H§¹¦¨
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

°ÝÃD¥X¦b°ò¥»¸ê®Æ¤u§@ªíªº«Ø¥ß,¨C¦¸¹J¦³·s«È¤á³£»Ý³]©w´¡¤J-¦WºÙ-©w¸q,¹w¯d¤Q­ÓªÅ®æ,¥H³Æ¿é¤J²£«~¸ê®Æ
¤@ª½­«½Æ³o°Ê§@¯uªº«Ü³Â·Ð,½Ð«e½ú½ç±Ð,¦³¨S¦³¤ñ¸û²³æªº¤èªk«Ø¥ß°ò¥»¸ê®Æ,Åý§Ú¦b·~ÁZ¼úª÷¤u§@ªí°µ¦P¼Ëªº·j´M(¥u·j´M¸Ó«È¤á­qÁʹLªº²£«~)

²S´I2.rar (22.16 KB)

chaoping22

TOP

¦^´_ 7# chaoping22


    ©w»ùÀ³¸Ó¦P²£«~­q»ù¬Û¦P¡A­nÅý¦U¼t°ÓÀu´f³¡¤À­n¥Î¥t¥~Äæ¦ì¬ö¿ý¡A³o¼Ë¤~¯à°÷¦³³W«h°O¿ý¸ê®Æ
¹ï¤½¦¡©Îµ{¦¡¼¶¼g¡A©ÎºØºØ°ò¥»¾Þ§@¤~¯àµo´§³Ì¤j¥\¯à¡A´î¤Ö§xÂZ¡C
«Øij¦n¦n¤F¸Ñ¸ê®Æ®w«Ø¥ßªº·Ç«h¡A¤~¯àÅý¤u§@¶¶§Q§¹¦¨
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦]¬°±`¤[¥H¨Ó°â»ù³£¬O¥Ñ·~°È­ûª½±µ¸ò«È¤áij»ù,«È¤á«ÜÃø±µ¨ü¸g¥Ñ¤½¥q©w»ù,¦b¥´§éªº¤è¦¡,
¦Ó¥B¦P·~¤]³£ª½±µ³ø»ù,¦b¬Û¤¬Ävª§¤§¤U,»ù®t«D±`¤j,¥Ñ¤£±o¦Û¤v,§Ú¦~ªñ50,¤~¶}©l¾Çexcel,
¹ï©óexcel³\¦h·Ç«hÁÙ¤£¤Ó¤F¸Ñ,ÁٽЫe½ú¦h¦h½ç±Ð,
¨Ò¦p§Ú³oªí¬O§_³]­p¿ù»~!ÁÙ¬O¨ç¼ÆÀ³¥Î¿ù»~.....µ¥!
½Ð«ü¥¿ÁÂÁÂ
chaoping22

TOP

§â­ìAÄæ¥t¤u§@ªí§@·~
¹w¯dµ§¼Æ¥i¥H°ÊºA½d³ò¨ú¥N,·s«È¤á¤]¤£¥Î·Ð´o
°ò¥»¸ê®Æ!B2:B11="¤ý®a¦³",¦pªG¥u¦³6µ§²£«~¸ê®Æ«ØB2:B7§Y¥i¤£¥Î¹w¯d

¸Õ°µ¤@¤U
©~µM¥d¦í¤F
§Ú±N"¤ý®a¦³"©w¸q°ÊºA¦WºÙ,
¸ê®Æ>ÅçÃÒ>=¤ý®a¦³  ³o¼Ë¬OOKªº
¸ê®Æ>ÅçÃÒ>=INDURECT(B9)  ³o¼Ë¬O¬O¿ù»~ªº

¤£ª¾¬°¦ó­ì¦]

Book1.rar (56.2 KB)

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

TOP

        ÀR«ä¦Û¦b : ¡i¥Í©R¦b©I§l¶¡¡j¦òªû»¡¡G¡u¥Í©R¦b©I§l¶¡¡C¡v¤HµLªkºÞ¦í¦Û¤vªº¥Í©R¡A§óµLªk¾×¦í¦º´Á¡AÅý¦Û¤v¥Ã¦í¤H¶¡¡C¬JµM¥Í©R¥h¨Ó³o»òµL±`¡A§Ú­Ì§óÀ³¸Ó¦n¦n¦a·R±¤¥¦¡B§Q¥Î¥¦¡B¥R¹ê¥¦¡AÅý³oµL±`¡BÄ_¶Qªº¥Í©R¡A´²µo¥¦¯uµ½¬üªº¥ú½÷¡A¬M·Ó¥X¥Í©R¯u¥¿ªº»ù­È¡C
ªð¦^¦Cªí ¤W¤@¥DÃD