- ©«¤l
- 17
- ¥DÃD
- 4
- ºëµØ
- 0
- ¿n¤À
- 21
- ÂI¦W
- 0
- §@·~¨t²Î
- WINDOWS
- ³nÅ骩¥»
- OFFICE 2003
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-6-15
- ³Ì«áµn¿ý
- 2018-10-16
|
¦^´_ u7490074
²q²q¬Ý¡A¬O¤£¬O³o¼Ë
=SUM(INDIRECT("Y"&ROW()&"¡GZ"&ROW()))
ML089 µoªí©ó 2014-9-29 21:40
¬O¥i¥H¥Î¡A¦ý¦pªG³æ¤@Àx¦s®æ¥´¤J="F"&ROW() .......°²³]¦b²Ä18¦C «h±o¨ì¬OF18¡A
¬O¤@©wn¥ÎINDIRECT("F"&ROW())¤~¯à±o¨ìF18Àx¦s®æªºÈ¶Ü? »P¦bA18Àx¦s®æ¿é¤J=F18¼gªk¡An¦h¤£¤Ö»yªk¹ï¶Ü.......¦]¬°§Ú¦³¦h§P§O¦¡¡A©Ò¥H¤@ÓÀx¦s®æ¤º©ñ¦nªøªº»yªk¡A¦p¤U¡A¦³¤èªk¯à¦Aºë²or§ó²©úªº»yªk¶Ü?
¡iÀx¦s®æA~L¤º®e¡j
°_©l¦~«× ²×¨´¦~«× ³æ¾Ú½s¸¹ 쥻ª÷ §Q²v Á`¤Ñ¼Æ Á`§Q®§¶O¥Î Á`¤ë¼Æ °_¤ë ¨´¤ë °_¤ë¤Ñ¼Æ ¨´¤ë¤Ñ¼Æ
2014¦~08¤ë04¤é 2014¦~10¤ë06¤é 40C000800 30,000,000 1.080% 63 55,920 3 8 10 28 5
¡iÀx¦s®æM~AD¤º®e¡j
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
0 0 0 0 0 0 0 24,853 26,629 4,438 0 0 0 0 0 0 0 0
¡iÀx¦s®æT2¤º®e¡j
¨ä¤¤¡A8¤ë¥÷=24853¤¸=IF(AND(U2<=12,DATE(YEAR($B3),MONTH($B3)+1,)=DATE(YEAR($B3),U2+1,)),ROUND($H3*($L3/$G3),0),IF(AND(U2>12,DATE(YEAR($B3),MONTH($B3)+1,)=DATE(YEAR($B3),(U2-12)+1,)),ROUND($H3*($L3/$G3),0),IF(AND(U2<=12,DATE(YEAR($C3),MONTH($C3)+1,)=DATE(YEAR($B3),U2+1,)),ROUND($H3*($M3/$G3),0),IF(AND(U2>12,DATE(YEAR($C3),MONTH($C3)+1,)=DATE(YEAR($B3)+1,(U2-12)+1,)),ROUND($H3*($M3/$G3),0),0))))+IF(AND(U2<=12,DATE(YEAR($B3),MONTH($B3)+1,)<DATE(YEAR($B3),U2+1,),DATE(YEAR($B3),U2+1,)<DATE(YEAR($C3),MONTH($C3)+1,)),ROUND($H3*(DAY(DATE(YEAR($B3)+1,(U2-12)+1,))/$G3),0),IF(AND(U2>12,DATE(YEAR($B3),MONTH($B3)+1,)<DATE(YEAR($B3)+1,(U2-12)+1,),DATE(YEAR($B3)+1,(U2-12)+1,)<DATE(YEAR($C3),MONTH($C3)+1,)),ROUND($H3*(DAY(DATE(YEAR($B3)+1,(U2-12)+1,))/$G3),0),0))
¡iÀx¦s®æU2¤º®e¡j
¨ä¤¤¡A9¤ë¥÷=26629¤¸=IF(AND(V2<=12,DATE(YEAR($B3),MONTH($B3)+1,)=DATE(YEAR($B3),V2+1,)),ROUND($H3*($L3/$G3),0),IF(AND(V2>12,DATE(YEAR($B3),MONTH($B3)+1,)=DATE(YEAR($B3),(V2-12)+1,)),ROUND($H3*($L3/$G3),0),IF(AND(V2<=12,DATE(YEAR($C3),MONTH($C3)+1,)=DATE(YEAR($B3),V2+1,)),ROUND($H3*($M3/$G3),0),IF(AND(V2>12,DATE(YEAR($C3),MONTH($C3)+1,)=DATE(YEAR($B3)+1,(V2-12)+1,)),ROUND($H3*($M3/$G3),0),0))))+IF(AND(V2<=12,DATE(YEAR($B3),MONTH($B3)+1,)<DATE(YEAR($B3),V2+1,),DATE(YEAR($B3),V2+1,)<DATE(YEAR($C3),MONTH($C3)+1,)),ROUND($H3*(DAY(DATE(YEAR($B3)+1,(V2-12)+1,))/$G3),0),IF(AND(V2>12,DATE(YEAR($B3),MONTH($B3)+1,)<DATE(YEAR($B3)+1,(V2-12)+1,),DATE(YEAR($B3)+1,(V2-12)+1,)<DATE(YEAR($C3),MONTH($C3)+1,)),ROUND($H3*(DAY(DATE(YEAR($B3)+1,(V2-12)+1,))/$G3),0),0)) |
|