- ©«¤l
- 14
- ¥DÃD
- 0
- ºëµØ
- 0
- ¿n¤À
- 53
- ÂI¦W
- 0
- §@·~¨t²Î
- XP, Vista & Window7
- ³nÅ骩¥»
- Office 2003 & 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-6-16
- ³Ì«áµn¿ý
- 2023-5-30
|
B3=INDEX($B$1:$F$1,1,IF(($A3+MATCH($B$2,$B$2:$E$2,0)-1)>$G$1,IF((MOD(($A3+MATCH($B$2,$B$2:$E$2,0)-1),$G$1))=0,(MOD(($A3+MATCH($B$2,$B$2:$E$2,0)-1),$G$1))+$G$1,(MOD(($A3+MATCH($B$2,$B$2:$E$2,0)-1),$G$1))),($A3+MATCH($B$2,$B$2:$E$2,0)-1)))
B4=INDEX($B$1:$F$1,1,IF(($A3+MATCH($C$2,$B$2:$E$2,0)-1)>$G$1,IF((MOD(($A3+MATCH($C$2,$B$2:$E$2,0)-1),$G$1))=0,(MOD(($A3+MATCH($C$2,$B$2:$E$2,0)-1),$G$1))+$G$1,(MOD(($A3+MATCH($C$2,$B$2:$E$2,0)-1),$G$1))),($A3+MATCH($C$2,$B$2:$E$2,0)-1)))
B5=INDEX($B$1:$F$1,1,IF(($A3+MATCH($D$2,$B$2:$E$2,0)-1)>$G$1,IF((MOD(($A3+MATCH($D$2,$B$2:$E$2,0)-1),$G$1))=0,(MOD(($A3+MATCH($D$2,$B$2:$E$2,0)-1),$G$1))+$G$1,(MOD(($A3+MATCH($D$2,$B$2:$E$2,0)-1),$G$1))),($A3+MATCH($D$2,$B$2:$E$2,0)-1)))
B6=INDEX($B$1:$F$1,1,IF(($A3+MATCH($E$2,$B$2:$E$2,0)-1)>$G$1,IF((MOD(($A3+MATCH($E$2,$B$2:$E$2,0)-1),$G$1))=0,(MOD(($A3+MATCH($E$2,$B$2:$E$2,0)-1),$G$1))+$G$1,(MOD(($A3+MATCH($E$2,$B$2:$E$2,0)-1),$G$1))),($A3+MATCH($E$2,$B$2:$E$2,0)-1)))
¿ï¨ú B3 ~ B6 ©¹¤U½Æ»s§Y¥i¡C |
|