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

¦³Ãö¥þ¶Ô¼úª÷­pºâ°ÝÃD

¦³Ãö¥þ¶Ô¼úª÷­pºâ°ÝÃD

¦U¦ì¤j¯«¦n
            ¦³¤@­Ó°ÝÃD¤@ª½§x´b¤F¦n¤[....³£¦b¤H¤u­pºâ ¡A¡A³W«h¬O³o¼Ëªº.......(1)¥þ¶Ô¤À2¦¸µ²ºâ¡A·í¤ë1¸¹-15¸¹¨S¦³(¨Æ¡B¯f¡B¥Í¯f)¥i»â800¤¸¡A·í¤ë16¸¹-31¸¹¨S¦³(¨Æ¡B¯f¡B¥Í¯f)¥i»â800¤¸  (2)·í¤ë¨ì¾¨Ì¤ñ¨Òµ²ºâ¨Ò¦p:3¤ë4¤é³ø¨ì(3/4~3/15)¦pªG¨S¦³(¨Æ¡B¯f¡B¥Í¯f)¡A¥i»â¥þ¶Ô¼úª÷800¤¸*(3/15-3/4¤§¤Ñ¼Æ°£¥H15)¡A¦pªG3/20³ø¨ì(3/20-3/31)¦pªG¨S¦³(¨Æ¡B¯f¡B¥Í¯f)¥i»â¥þ¶Ô¼úª÷800¤¸*(3/31-3/20¤§¤Ñ¼Æ°£¥H15).....²{¦bªp´b¦p¦ó¤U¤½¦¡¥hÂê©w·í¤ë¨ìÂ÷¾ªº°ÝÃD????><"¨D¤j¯«¨ó§U~~·P¿E¸Uªâ(¨ç¼Æ­n¦p¦ó¤U³£¥i¼{¨ì©O

¥þ¶Ô¼úª÷.rar (18.46 KB)

yvonne

¤W¥b¤ë
=IF(OR(COUNTIF(E4:S4,{"¨Æ","¯f"})),0,ROUND(800*MAX(0,MIN(D4,S$2)-MAX(C4,E$2)+1)/15,))

¤U¥b¤ë
=IF(OR(COUNTIF(T4:AI4,{"¨Æ","¯f"})),0,ROUND(800*MAX(0,MIN(D4,AF$2+2)-MAX(C4,T$2)+1)/15,))

2¤ë¤U¥b¤ë¤£¨¬15¤Ñ, ¥H15¤Ñ­p
¨ä¥¦¤ë31¤éªº, ¥þµø30¤Ñ­p

TOP

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


    ·PÁÂ&#128591; ­ã¤j¯«ªº¨ó§U..§Ú¥ý®ø¤Æ¤@¤U..·PÁÂ
yvonne

TOP

        ÀR«ä¦Û¦b : ¬°¤H³B¥@­n¤p¤ß²Ó¤ß¡A¦ý¤£­n¡u¤p¤ß²´¡v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD