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

[µo°Ý] ½Ð±Ð ²¤Æ¨ç¼Æ¤ÎIF°ÝÃD

[µo°Ý] ½Ð±Ð ²¤Æ¨ç¼Æ¤ÎIF°ÝÃD

½Ð°Ý¦U¦ì«e½ú
§Ú¦³¤@¥÷ªí³æ¬O­pºâ¥[¯Zªº
¥Ø«e§Æ±æ°µªk¬°¦bB6¿é¤J¥[¯Z®É¶¡
ÅýB3¤ÎB4¦Û°Ê­pºâ®É¶¡
­YB6µL¥[¯Z¡A«hB3¸òB4³£¬°ªÅ¥Õ

¦³¨â­Ó°ÝÃD½Ð±Ð
1.B3¸òB4ªº¤½¦¡¥i¥H²¤Æ¶Ü¡H
2.·íB6µL¥[¯Z¬°ªÅ¥Õ®É¡A¦p¦óÅý±ßÀ\¨º¤@¦æªº§PÂ_¬°ªÅ¥Õ©O¡H
p.s±ßÀ\ªº¤½¦¡§PÂ_¬°·í¤Ñ¥[¯Z¶W¹L(¥]§t)1.5¤p®É§Y°O "1"¡A¤£¨¬1.5¤p®É«hªÅ¥Õ
0713_1.zip (9.66 KB)

¥H¤W¨â­Ó°ÝÃD¦A³Â·Ð¦U¦ì«e½ú«ü¾É«ü¾É¤F¡A«á¾Ç·P¿E¤£ºÉ¡AÁÂÁ¡C

B3//
=MIN(2,MAX(,B6*24-17.5))

B4//
=MAX(,B6*24-17.5-2)

B5//
=IF(N(B3)>=1.5,1,0)

TOP

¦^´_ 2# ­ã´£³¡ªL

·PÁ­㴣³¡ªLª©¥D¤j¤jªº¦^ÂÐ
¤½¦¡´ú¸ÕOK

¥t¥~¤£ª¾¹Dª©¥D¤j¤j¬O§_¥i¥H»¡©ú¤@¤U¤½¦¡©O¡H

¢Ð¢µ¡¯¢±¢³¬O¤°»ò·N«ä©O¡H

¥t¥~N(B3)¤¤ªºN¥Îªk¬O±N«D¼Æ¦rÂà´«¦¨¼Æ¦r
½Ð°Ý¦³¬ÛÃöNªº¥Îªk»¡©úºô­¶¶Ü?

TOP

¦^´_ 3# ¬PªÅÉ@¦ÐÁl


®É¶¡¬O"¤p¼Æ", ¥²¶·­¼¥H24==´«ºâ¤p®É
N(""), ¤å¦r©ÎªÅ¦r²Å³£¤j¤_¥ô¤@¼Æ¦r, ¥[N()µø¬°0

TOP

¦^´_ 4# ­ã´£³¡ªL

·PÁ­㴣³¡ªLª©¥D¤j¤jªº¸Ñ»¡
«á¾Ç¤w¤F¸Ñ¡AÁÂÁ±z¡I

TOP

        ÀR«ä¦Û¦b : ¯àµ½¥Î®É¶¡ªº¤H¡A¥²¯à´x´¤¦Û¤v§V¤Oªº¤è¦V¡C
ªð¦^¦Cªí ¤W¤@¥DÃD