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

¥X¶Ôªí¦p¦ó¥Î¨ç¼Æ§PÂ_

¦^´_ 2# keovin790916
¤£©úÁA1#ªº°ÝÃD»Ý¨D¬°¦ó¡H
¥i¥H¸Ô­z¤@¤U¡H
ÁÂÁ¡I

TOP

¥»©«³Ì«á¥Ñ p212 ©ó 2015-3-20 15:37 ½s¿è

¦^´_ 6# keovin790916
1¡B¼W¥[»²§UÄæ¡u¥X¶Ô¼Ð·Ç¡vG2:G5
2¡BÀx¦s®æE2¿é¤J¤½¦¡
=IF($D2-LOOKUP(,0/(MIN(($G$2:$G$5-$D2)^2)=($G$2:$G$5-$D2)^2),$G$2:$G$5)>0,"¿ð¨ì",IF($D2-LOOKUP(,0/(MIN(($G$2:$G$5-$D2)^2)=($G$2:$G$5-$D2)^2),$G$2:$G$5)<0,"¦­¨ì","·Ç®É"))
¦V¤U½Æ»s
½Ð°Ñ¦Ò¡I
ª`¡G¤W¦C¤½¦¡¤§ LOOKUP(,0/(MIN(($G$2:$G$5-$D2)^2)=($G$2:$G$5-$D2)^2),$G$2:$G$5)³¡¤À
°Ñ¦Ò http://forum.twbts.com/thread-10765-1-1.html    ML089ª©¤j¸ÑÃD¤º®e

fig.jpg (86.59 KB)

fig.jpg

¥X¶Ôªí³]©w_2.zip (8.76 KB)

TOP

¦^´_ 6# keovin790916
­Y¤£·Q¼W¥[»²§UÄæ¡A¥i¥H©w¸q¦WºÙ³B²z(¦p¹Ï)
Àx¦s®æE2¿é¤J¤½¦¡
=IF($D2-LOOKUP(,0/(MIN((¤W¯Z®É¨è-$D2)^2)=(¤W¯Z®É¨è-$D2)^2),¤W¯Z®É¨è)>0,"¿ð¨ì",IF($D2-LOOKUP(,0/(MIN((¤W¯Z®É¨è-$D2)^2)=(¤W¯Z®É¨è-$D2)^2),¤W¯Z®É¨è)<0,"¦­¨ì","·Ç®É"))
¦V¤U½Æ»s
½Ð°Ñ¦Ò¡I

fig2.jpg (23.37 KB)

fig2.jpg

TOP

¥»©«³Ì«á¥Ñ p212 ©ó 2015-3-23 10:10 ½s¿è

¦^´_ 12# keovin790916
©å¨£¡A½Ð°Ñ¦Ò¡I

¥X¶Ôªí³]©w_2.zip (9.28 KB)

TOP

¥»©«³Ì«á¥Ñ p212 ©ó 2015-3-24 10:33 ½s¿è

¦^´_ 14# keovin790916
13#°Ýªº¸ê®ÆÄæ¦ì°t¸m¦ü¥G»P­ì°Ý¤£¦P¡I
¥i§_´N13#ªºÀɮ׸ê®Æ(©Î¥t°_½d¨ÒÀÉ)¡A¥[µù±z±ý¼W¦CªºÄæ¦ì¡B¹w´Áµª®×...µ¥¡A¥H¨Ñ¤@¦P½m²ß¡B¬ã¨s¡H
ÁÂÁ¡I

TOP

¥»©«³Ì«á¥Ñ p212 ©ó 2015-3-25 08:55 ½s¿è

¦^´_ 16# keovin790916
1¡B14#©Ò´£¡u·í¤Ñ¥u¥X¶Ô¤W¤È¤W¯Z ¤§«á¤U¤È¤U¯Zªº¡v(³sÄò­È¶ÔªÌ)¡A16#½d¨ÒÀɤ§KÄæÀ³¬O¥¿½Tªº¡C¦ÓHÄæ¦ì­Y±ý¦A¼Ðµù¡A«h«Øij¤½¦¡¬°
=CHOOSE(MATCH(TEXT(LOOKUP(,0/(MIN((G¸s²Õ-$F2)^2)=(G¸s²Õ-$F2)^2),G¸s²Õ),"hh:mm"),{"08:00";"12:00";"13:30";"17:00"},0),"­È¯Z","","­È¯Z","")
²£¥Í¡u­È¯Z¡vªºµ²ªG
2¡B16#½d¨ÒÀɪº¸ê®Æ¬Ò¬°­È¶Ô¬ö¿ý¡A¬G­pºâ¡u¥X®u¤Ñ¼Æ¡v«Øij¤½¦¡¬°
=SUMPRODUCT(1/COUNTIF($D$2:$D$17,$D$2:$D$17))
3¡B16#½d¨ÒÀɪºG6Àx¦s®æ©Ò­z¡u·|¹J¨ì¦³¨â¤Ñ¥´¥dªº¡v¡A¬°¦ó¡H
4¡B­YE2Àx¦s®æ¬°¤â°Ê¿é¤J¡A«h¥iÂÇ¿é¤J=TEXT(D2,"aaaa")¡A¦V¤U½Æ»s¤½¦¡¡A²£¥Í¡u¬P´ÁX¡vªºµ²ªG¡F©Î¿é¤J=TEXT(D2,"aaa")²£¥Í¡u¶gX¡vªºµ²ªG¡C
¥H¤W©å¨£¡A½Ð°Ñ¦Ò¡I

TOP

        ÀR«ä¦Û¦b : ·R¤£¬O­n¨D¹ï¤è¡A¦Ó¬O­n¥Ñ¦Û¨­ªº¥I¥X¡C
ªð¦^¦Cªí ¤W¤@¥DÃD