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

[µo°Ý] ½Ð°Ý¤T­Ó°Ï¶¡¦p¦ó«Øºc¤£¦P¨Mµ¦(¦pªþÀÉ)

[µo°Ý] ½Ð°Ý¤T­Ó°Ï¶¡¦p¦ó«Øºc¤£¦P¨Mµ¦(¦pªþÀÉ)

¤j¤j,¤S¨Ó½Ð±Ð±z¤F! ­Y¦³¤T­Ó°Ï¶¡²Õ¦X¦Ó¦¨ªº¤£¦P¨Mµ¦¡A¦p¦ó«Øºcµ{¦¡? ·PÁ help.rar (11.77 KB) ¡C

¬O§Ú¼gªº«Ü½ÆÂø¬Ý¤£À´¶Ü? «ç»ò¨S¤H¯à¸Ñµª¤X? ¤£¹LÁÙ¬OÁÂÁ¦U¦ì¤j¤j¡A¬Ý¨Ó¬OµL¸Ñ¤F

TOP

§Aªº²Ä23µ§¸ê®Æ¬O§_§PÂ_¦³»~¡H

TOP

·PÁÂtoomellowhaw¤j¤jªº¦^À³¡A¯uªº«Ü·P°Ê¡A¥H¬°¨S¤H²z§Ú¤F!¨ä¹ê§Úªº¹êÅ禳¨âºØ¡A²Ä1ºØ´N¹³§ÚÀɮפW©Ò¼gªº¡A­Y²Ä2¦¸¤~¸ó¶V¤W­­®É¡A«h¤£²z³o­Ó°T¸¹¡C¦Ó²Ä2ºØ»Ý¨D´N¹³±z´£¨ìªº¡A"À³¦³³æ¦ì"­n§ï¦¨"1"¤~¹ï¡C­Õ­Y¤j¤j±z¥i¥H¼g¥X²Ä2ºØ¹êÅ窺µ{¦¡¡A§Ú´N«D±`·P¿E±z¤F¡A½Ð±z¤£¥Î¥h²z·|§Úªº²Ä1ºØ±¡§Î¡A¯u±µ±N²Ä23µ§¸ê®Æ§ï¦¨1§Y¥i¡AÁÂÁ±z~

TOP

©óF13¿é¤J¤½¦¡
=F12+SUMPRODUCT((B13>C13:E13)-(B12>C12:E12))*(SUMPRODUCT((B13>C13:E13)-(B12>C12:E12))<>F12)
©¹¤U©Ô

TOP

½Ð°Ý­Y¥Ñ¤W­­¤W¤èª½±µ¶^¨ì¤U­­¤U¤è(¨Ò¦pB13ªº¼Æ¾Ú§ï¬°97®É)¡A¬°¦óÀ³¦³³æ¦ì·|ÅÜ-2 ?À³¸Ó¬O-1¤~¹ï!½ÐÀ°¦£¸Ñ´b¡AÁÂÁ¤j¤j±z~

TOP

¨Ì¾Ú³]©w¡A¸ó¶V¤@­Ó°Ï¶¡¼W´î1
¤W­­¥H¤W¸ó¨ì¤U­­¥H¤U¤w¸ó¶V3¦¸¤F
1-3=-2

TOP

­×§ï¼W´îÃä¬É­È­pºâ¡A¸ÕµÛ¦A§ï§ï¬Ý..
©óF13¿é¤J¤½¦¡
=F12+ROUND(SUMPRODUCT((B13>C13:E13)-(B12>C12:E12))*(SUMPRODUCT((B13>C13:E13)-(B12>C12:E12))<>F12)*0.8,)
©¹¤U©Ô

TOP

toomellowhaw¤j¤j±z¦n¡A½Ð°Ý­Y±NB25Äæ¦ìªº¸ê®Æ§ï¬°95®É¡AÀ³¦³³æ¦ìÅܦ¨0¡A³o¼Ë¬O¿ù»~ªº¡A¥¿½TªºÀ³¦³³æ¦ì¬O1¤~¹ï¡A¤£ª¾³o¦p¦ó¸Ñ¨M? ¯uªº«Ü·PÁ±z~

TOP

B25Äæ¦ìªº¸ê®Æ§ï¬°95®É.....¨Ã¨S¦³¹F¨ì±z¨î©wªº¼W´î±ø¥ó..
95¨ÌµMºû«ù¦b§¡­È»P¤W­­¤§¶¡¡A»PB24¸ê®Æ±¡ªp¬Û¦P....¦]¦¹¤£¼W¥[..

TOP

        ÀR«ä¦Û¦b : ¤H­nª¾ºÖ¡B±¤ºÖ¡B¦A³yºÖ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD