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

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

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

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

®É¶¡¦n¹³·|¥d¨ì




¥X¶Ôªí³]©w.rar (6.14 KB)

§Ú¥Îif  ¦n¹³¤£¯à§PÂ_

TOP

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

TOP

§Ú­n¥Îif  d2>08:00,"¿ð¨ì"     ³o¼Ë  ¼Ð°O

TOP

¦³¥i¥H§PÂ_®É¶¡ªº ¨ç¼Æ?    °²³]§Ú08:00  ¶W¹L®É¶¡ ´NÅã¥Ü¥X¿ð¨ì  ¨S¶W¹L´NªÅ¥Õ¡C   ½Ð°Ý¤j¤j³o­n¥Î¬Æ»ò¨ç¼Æ?

TOP

¦³¿ìªk¬O

§Úªº¸ê®Æ¬O

08:01
12:00
13:20
17:00

¤@¦¸¥|­Ó¤ñ¹ï  ¸ê®Æ    >08:00  ¿ð¨ì   =<08:00 ¨S¿ð¨ì  
                                     >12:00   OK      <12:00   ¦­°h
                                    >13:30  ¿ð¨ì   =<13:30 ¨S¿ð¨ì
                                      >17:00   OK      <17:00   ¦­°h   

¦p¦ó¥Î¨ç¼Æ¨Ó§PÂ_   ¥ÎIF ¦n¹³¨S¿ìªk¦hºØ±ø¥óÅý¥L§¹¦¨

TOP

¦^´_ 4# keovin790916

¦bEXCEL¸Ì®É¶¡µLªkª½±µ¥Î08:00¨Óªí¥Ü
¹ïEXCEL¨Ó»¡08:00=0.3333....(8/24)  08:30=0.35416....(8.5/24)  ¥H¦¹Ãþ±À
©Ò¥H¨ç¼Æ­n§ï¦¨  =IF(D2<=0.3334,"","¿ð¨ì")
¥H¤W¬O§Ú­Ó¤Hªº²L¨£,¦p¦³¿ù»~,ÁٽЦU¦ì¤j¤jµ¹¤©«ü±Ð~~

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

·PÁ¦U¦ì¤j¤j´£¨Ñ   ¡A¤S¦h¾Ç¨ì¤F¤@¨Ç  §Ú¦A¸Õ¸Õ¬Ý¡C

TOP

        ÀR«ä¦Û¦b : ¦h°µ¦h±o¡C¤Ö°µ¦h¥¢¡C
ªð¦^¦Cªí ¤W¤@¥DÃD