°Ñ¦Òªþ¥ó¡Jhttp://www.FunP.Net/646210
¦WºÙ©w¸q¡J
R_R=$R7¡F T_3=T$3¡F T_5=T$5¡F X=$R7+T$3¡F Y=T$5-$R7¡F Z =MOD(T$5+Y,$R$6)
A_1
=OR($R7="",T$5="",$R7>=T$5,$R7+T$3=T$5-$R7,T$5=$R7+T$3)
A_2
=OR($R7="",T$5="",$R7>=T$5,$R7+T$3=T$5-$R7,T$5<>$R7+T$3)
B_1
=MOD(T$3,Y)=0
C_1
T$5=$R7+T$3
C_2
T$5<>$R7+T$3
G_1
=OR($R7="",T$5="",$R7>=T$5,$R7+T$3=T$5-$R7,MOD(T$3,Y)<>0,T$5=$R7+T$3)
G_2
=OR($R7="",T$5="",$R7>=T$5,$R7+T$3=T$5-$R7,MOD(T$3,Y)<>0,T$5<>$R7+T$3)
R_Y
=OR($R$5=OFFSET($I$6,Y,1,,7))
S_1
=OR(SUM(($R$5=OFFSET($I$6,T$5,1,,7))*OFFSET($I$6,$R7,1,,7))=OFFSET($I$6,X,1,,7))
S_2
=OR(SUM(($R$5=OFFSET($I$6,T$5,1,,7))*OFFSET($I$6,Z,1,,7))=OFFSET($I$6,Y,1,,7))
»¡©ú¡J
Sheet1!T7
=IF(G_1,"",IF(S_1*S_2,Y,""))
·íR7=ªÅ¥Õ©ÎT5=ªÅ¥Õ©ÎR7¤j©óµ¥©óT5©ÎR7+T3=T5-R7©ÎT3°£¥HYªº¾l¼Æ¤£µ¥©ó0©ÎT5µ¥©óR7+T3®É¡AT7Åã¥ÜªÅ¥Õ¡F
¤S·íT5´Á¼Æªº$R$5È(EX:K97=11)¡A¨ä¦bR7´Á¼Æªº¹ïÀ³È(EX:K94=26)¦³Åã¥Ü¦bR7+T3´Á¼Æ(EX:N103=26)
¥BT5´Á¼Æªº$R$5È(EX:K97=11)¡A¨ä¦bT5+Y´Á¼Æªº¹ïÀ³È(EX:K100=04)¦³Åã¥Ü¦bT5-R7´Á¼Æ(EX:K9=04)®É~
«hT7Åã¥ÜY(T5-R7)È(EX:T94=3)¡A§_«hÅã¥ÜªÅ¥Õ¡C
Sheet2!T7
=IF(G_2,"",IF(S_1*R_Y,Y,""))
·íR7=ªÅ¥Õ©ÎT5=ªÅ¥Õ©ÎR7¤j©óµ¥©óT5©ÎR7+T3=T5-R7©ÎT3°£¥HYªº¾l¼Æ¤£µ¥©ó0©ÎT5¤£µ¥©óR7+T3®É¡AT7Åã¥ÜªÅ¥Õ¡F
¤S·íT5´Á¼Æªº$R$5È(EX:K97=11)¡A¨ä¦bR7´Á¼Æªº¹ïÀ³È(EX:K88=23)¦³Åã¥Ü¦bR7+T3´Á¼Æ(EX:N97=23)
¥BT5´Á¼Æªº$R$5Ȧ³Åã¥Ü¦bT5-R7´Á¼Æ(EX:L15=11)®É~
«hT7Åã¥ÜY(T5-R7)È(EX:T88=9)¡A§_«hÅã¥ÜªÅ¥Õ¡C
¤Wz2Ó¤½¦¡¸g´ú¸Õ«á¡J
¨ä¤¤ªºG_1©MG_2¤§·íR7¤j©óµ¥©óT5«hÅã¥ÜªÅ¥Õ¡A·|¦]MOD(T$3,Y)<>0¦Ó¥¢®Ä(EX:T97=#DIV/0!)¡A
©Ò¥H¡A¥u¦n±N¨ä©î¸Ñ¬°~
Sheet1-1!T7
=IF(A_1,"",IF(B_1*S_1*S_2,Y,""))
Sheet2-1!T7
=IF(A_2,"",IF(B_1*S_1*R_Y,Y,""))
»Ý¨D¡J
1.½Ð±ÐG_1©MG_2§ó²z·Qªº¼gªk¡C
2.½Ð±N¤G¦¡¤½¦¡¦X¨Ö¬°¤@¦¡(½Ð¾¨¶q²¤Æ)
¥H¤W Àµ½Ð¦U¦ì¥ý¶i¡B«e½ú¤£§[½ç±Ð! ÁÂÁÂ! |