ML089

®æ¦¡¤Æ±ø¥ó¤½¦¡

¥D¥ð(¤£¥i¥H¿ï)               
B2=MOD(INT((B2-$B$2)/56),7)=WEEKDAY(B2,3)               

               
¤p®§ (¥i¥H¿ï)               
B2 =N(MOD(INT((B2-$B$2)/56)+1,7) = WEEKDAY(B2,3)) *(MOD(INT((B2-$B$2)/7),2)=IF($K$2=8,1,0))
²¤Æ¤Ö¤@­ÓMOD

ML089

®æ®æ¦¡¤Æ¤½¦¡ B2

¥D¥ð (¥i½Õ¿ï J2)       
B2 =N(MOD(INT((B2-$B$2)/56)+MATCH($J$2,$B$1:$H$1,)-1,7)=WEEKDAY(B2,3))       
WEEKDAY(B2,3)¬O¬P´Á¤@¥Ñ0¶}©l       
56¬O8©P¤Ñ¼Æ(7*8)       
       
       
¤p®§ (¥i½Õ¿ï K2)       
  9.6 ®É¡A¦b²Ä 1¡B3¡B5¡B7 ¬P´Áªº¥D¥ð¤é«á­±¥[¦h¤@¤Ñ
  8    ®É¡A¦b²Ä 2¡B4¡B6¡B8 ¬P´Áªº¥D¥ð¤é«á­±¥[¦h¤@¤Ñ
  ª`·N¡A¬P´Á¤é®É¬O¸Ó©P¬P´Á¤@¥ð
B2 =N(MOD(INT((B2-$B$2)/56)+MATCH($J$2,$B$1:$H$1,)-0,7)=WEEKDAY(B2,3))
*(MOD(INT((B2-$B$2)/7),2)=IF($K$2=8,1,0))       

RCondition_Fix ¥D¥ð¤p®§¨C¤K­Ó¬P´Á´N¤@­Ó´`Àô.rar (67.18 KB)

¤U¸ü¦¸¼Æ: 6

2017-1-15 05:12

ML089

¦^´_ 4# maiko

¬P´Á¤é¥D¥ð±µ¤U©P¬P´Á¤@¥D¥ð®É¡A­Y¤p®§¬O³æ©P¥ð®É´N·|³y¦¨¤T¤Ñ³s°²¡A­Y¤p®§¬OÂù©P¥ð®É´N¤£·|³y¦¨¤T¤Ñ³s°²¡A³o»P52©P´`Àô¨S¦³Ãö«Y¡C
³o³¡¤À»Ý¨D¦³¨Ç©_©Ç?

ML089

¦^´_ 6# maiko

>>¬O³o¼Ë­n¨Dªº¡A¨C¦¸³£¦b¥D¥ð¬O ¬P´Á¤é ´« ¬P´Á¤@ªº®É­Ô¡A¦pªG¬OÂù©Pªº¸Ü¡A¨º»ò¬P´Á¤@¤]¬OÂù©P¡]³o®É¤~¦³¾÷·|³sÄò¤T¤Ñ¡^¡A¤Ï¤§¦pªG¬O³æ©Pªº¸Ü¡A¨º»ò¬P´Á¤@¤]¬O³æ©P¡]³o®É¥u¦³³sÄò¨â¤Ñ¡^¡C
>>½T¹ê¬O¸ò56­Ó¬P´ÁµLÃö¡A¥u¬O¨C¦¸³£¦b¬P´Á¤é´«¬P´Á¤@ªº®É­Ô¡A³o¼Ëºâ°_¨Ó´N¹j¤F 7 * 8 = 56 ­Ó¬P´Á¤F¡C

>>ÁÂÁÂ! ½Ð¦h¶O«ä¶q¤@¤U¡A³o¼Ëªº¸Ü¬O«ç»ò¹F¦¨ªº?


¤p®§¬OÂù©P¥ðªº¨S¦³¦¹°ÝÃD
¤p®§¬O³æ©P¥ðªº¦b¥D¥ð¬°¬P´Á¤é§ï¬°¬P´Á¤@¨º¤K©P¥þ³¡§ï¬°Âù©P¥ð¶Ü? ¦A¹L 56 ­Ó¬P´Á¦A§ï¬°³æ©P¥ð®ÉÁÙ¬O¦³¦¹°ÝÃD(³s¥ð¤T¤Ñ)?
°ÝÃD¬O§_§ï¬° ¥D¥ð¬°¬P´Á¤é§ï¬°¬P´Á¤@¨º¤K©P¤p®§¥þ³¡¬°Âù©P¥ð¡A¨ä¥L¤£Åܳo¼Ë¶Ü?

ML089

¦^´_ 8# maiko

1. ¤p®§¥þ³¡±Æ¦bÂù©P´N¥i¥H¨M¸Ñ°ÝÃD

2. ¤@¦~¤@¦¸³sÄò¤T¤Ñ¡A³o·|¦³¬Æ»ò¼vÅT? ÁÙ¤£¬O¨C8©P¥ð8+4¤Ñ

ML089

¦^´_ 10# maiko

³Ìªñ¦£µyºC¨Ó°Q½×
¦]¬°±Æ¦CÅÞ¿è¤W¤´¦³¨Ç¥¼¸Ñ¡A¿ð¿ð¥¼¯à¤U¤â¡A
¤p®§³¡¤À«Øij¬P´Á¤G®É¥ý³]¬°Âù©P¥ð¡A¸ò§Aªºªì¨B­n¨D¬Û¦P

¤p®§B2®æ¦¡¤Æ¤½¦¡
=N(MOD(INT((B2-$B$2)/56)+MATCH($J$2,$B$1:$H$1,)-0,7)=WEEKDAY(B2,3)) * (MOD(INT((B2-$B$2)/7),2)=IF(WEEKDAY(B2,3)=1,1,IF($K$2=8,1,0)))
   
¤½¦¡»¡©ú =(¬P´Á§PÂ_) * (³æÂù©P§PÂ_)