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

[µo°Ý] ¨Ì²Ö­p¼Æ¶q­pºâ¤£¦P³æ»ù°ÝÃD½Ð±Ð

[µo°Ý] ¨Ì²Ö­p¼Æ¶q­pºâ¤£¦P³æ»ù°ÝÃD½Ð±Ð

¤p©f³Ìªñ§Ö³Q¦¹ªí·d¨ìÀYµh¡A¬G¤W¶ÇÀÉ®× ¼Æ¶q³æ»ùªí.rar (4.43 KB) ¨Ó¨D±Ð¸Ñ¨M¤è¦¡¡A
°²³]1¤ë³æ¦ì¤p©óµ¥©ó70,000¡A«h¥H1¤ë³æ¦ìx³æ¦ì¤º³æ»ù­pºâ¡G­Y¤j©ó70,000«h¥H(70,000X³æ¦ì¤º³æ»ù)+(¶W¥X70,000³æ¦ìX³æ¦ì¥~³æ»ù)­pºâ¡A
2¡B3¤ë¬O¥H²Ö­pªº¤è¦¡¨Ì¤W­±ªº©w²v¨Ó­pºâ¡A¥Hªþ¥ó¨Ó»¡¡A¦X­p1¤ëªº³æ¦ì¤´¤£¨ì70,000¡A¬GÁÙ¬O¨Ì³æ¦ì¤º³æ»ù­pºâ¡A
¤ñ¸û½ÆÂøªº¬O¡A4¤ë·|¦³·sªº³æ¦ì©M³æ»ù¡A¦ý¤´­n¦Ò¼{­Y1~3¤ë³æ¦ì¼Æ­Y¤£¨ì70,000¡A´N­n¥H70,000ªº®tÃB­pºâ¸É¨¬¡A¶W¹L´N¥Î·sªº³æ»ù¨Ó­pºâ¡A
ªþ¤WÀÉ®×»¡©ú¦UºØ¥i¯àªºª¬ªp¡A¯à§_À°¤p©f¦b¤p­p¨º³]¤½¦¡¡A¿é¤J¼Æ¶q§Y¥i­pºâ¥X¨Ó¡A·PÁ¡I

¤p©f³Ìªñ§Ö³Q¦¹ªí·d¨ìÀYµh¡A¬G¤W¶ÇÀɮרӨD±Ð¸Ñ¨M¤è¦¡¡A
°²³]1¤ë³æ¦ì¤p©óµ¥©ó70,000¡A«h¥H1¤ë³æ¦ìx³æ¦ì¤º³æ ...
paddyliu µoªí©ó 2013-10-20 18:23

·íÀx¦s®æªº¤½¦¡Åܪº«Ü½ÆÂø®É,
¥i¥H¦Ò¼{¥ÎªÅ¶¡¨Ó´«¨ú¤½¦¡ªºÂ²³æ¤Æ:
¼Æ¶q³æ»ùªí-a.zip (7.17 KB)

TOP

¦^´_ 2# luhpro
±z¦n¡A¦]§ÚµL¤U¸üÅv­­¡A¤£ª¾¯à§_±N¼gªk¶Kµ¹§Ú¡AÁÂÁ¡I:)

TOP

¥»©«³Ì«á¥Ñ luhpro ©ó 2013-10-22 23:00 ½s¿è

¦^´_ 3# paddyliu
¦@ 3 ­Ó Sheet :  Sheet1   1~3¤ë   4~6¤ë


Sheets("Sheet1") ªº²Ä 2 ¦C:
            D          E      F     G ...
-- +-----------------------------------------------------
2  |   1¤ë³æ¦ì  1¤ë¤p­p  2¤ë  2¤ë¤p­p  3¤ë  3¤ë¤p­p  4¤ë  4¤ë¤p­p  5¤ë  5¤ë¤p­p  6¤ë  6¤ë¤p­p

E3='1~3¤ë'!B3+'1~3¤ë'!C3
G3='1~3¤ë'!E3+'1~3¤ë'!F3
I3=IF(H3="","",'1~3¤ë'!H3+'1~3¤ë'!I3)
K3=IF(J3="","",'4~6¤ë'!B3+'4~6¤ë'!C3+'4~6¤ë'!D3)
M3=IF(L3="","",'4~6¤ë'!F3+'4~6¤ë'!G3+'4~6¤ë'!H3)
O3=IF(N3="","",'4~6¤ë'!J3+'4~6¤ë'!K3+'4~6¤ë'!L3)


Sheets("1~3¤ë") ªº²Ä 2 ¦C:

            A          B       C      D ...
-- +-----------------------------------------------------
2  |   1¤ë²Ö­p  ³æ¦ì¤º  ³æ¦ì¥~  2¤ë²Ö­p  ³æ¦ì¤º  ³æ¦ì¥~  3¤ë²Ö­p  ³æ¦ì¤º  ³æ¦ì¥~

A3=Sheet1!D3
B3=IF(A3<=Sheet1!$A3,A3*Sheet1!$B3,Sheet1!$A3*Sheet1!$B3)
C3=IF(A3<=Sheet1!$A3,0,(A3-Sheet1!$A3)*Sheet1!$C3)
D3=A3+Sheet1!F3
E3=IF(D3<=Sheet1!$A3,D3*Sheet1!$B3,Sheet1!$A3*Sheet1!$B3)
F3=IF(D3<=Sheet1!$A3,0,(D3-Sheet1!$A3)*Sheet1!$C3)
G3=D3+Sheet1!H3
H3=IF(Sheet1!H3="","",IF(G3<=Sheet1!$A3,G3*Sheet1!$B3,Sheet1!$A3*Sheet1!$B3))
I3=IF(Sheet1!H3="","",IF(G3<=Sheet1!$A3,0,(G3-Sheet1!$A3)*Sheet1!$C3))


Sheets("4~6¤ë") ªº²Ä 2 ¦C:

           A         B         C           D ...
-- +-----------------------------------------------------
2  |   4¤ë²Ö­p  ³æ¦ì¤º1  ³æ¦ì¤º2  ³æ¦ì¥~  5¤ë²Ö­p  ³æ¦ì¤º1  ³æ¦ì¤º2  ³æ¦ì¥~  6¤ë²Ö­p  ³æ¦ì¤º1  ³æ¦ì¤º2  ³æ¦ì¥~


A3='1~3¤ë'!G3+Sheet1!J3
B3=IF(Sheet1!J3="","",IF('4~6¤ë'!A3<=Sheet1!$A3,'4~6¤ë'!A3*Sheet1!$B3,Sheet1!$A3*Sheet1!$B3))
C3=IF(Sheet1!J3="","",IF(A3<=Sheet1!$A3+Sheet1!$A11,IF(A3<=Sheet1!$A3,0,(A3-Sheet1!$A3)*Sheet1!$B11),Sheet1!$A3*Sheet1!$B3+Sheet1!$A11*Sheet1!$B11+(A3-Sheet1!$A3-Sheet1!$A11*Sheet1!$C11)))
D3=IF(Sheet1!J3="","",IF(A3<=Sheet1!$A3+Sheet1!$A11,0,(A3-Sheet1!$A3-Sheet1!$A11)*Sheet1!$C11))
E3=A3+Sheet1!L3
F3=IF(Sheet1!P3="","",IF('4~6¤ë'!E3<=Sheet1!$A3,'4~6¤ë'!E3*Sheet1!$B3,Sheet1!$A3*Sheet1!$B3))
G3=IF(Sheet1!P3="","",IF(E3<=Sheet1!$A3+Sheet1!$A11,IF(E3<=Sheet1!$A3,0,(E3-Sheet1!$A3)*Sheet1!$B11),Sheet1!$A3*Sheet1!$B3+Sheet1!$A11*Sheet1!$B11+(E3-Sheet1!$A3-Sheet1!$A11*Sheet1!$C11)))
H3=IF(Sheet1!P3="","",IF(E3<=Sheet1!$A3+Sheet1!$A11,0,(E3-Sheet1!$A3-Sheet1!$A11)*Sheet1!$C11))
I3=E3+Sheet1!N3
J3=IF(Sheet1!T3="","",IF('4~6¤ë'!I3<=Sheet1!$A3,'4~6¤ë'!I3*Sheet1!$B3,Sheet1!$A3*Sheet1!$B3))
K3=IF(Sheet1!T3="","",IF(I3<=Sheet1!$A3+Sheet1!$A11,IF(I3<=Sheet1!$A3,0,(I3-Sheet1!$A3)*Sheet1!$B11),Sheet1!$A3*Sheet1!$B3+Sheet1!$A11*Sheet1!$B11+(I3-Sheet1!$A3-Sheet1!$A11*Sheet1!$C11)))
L3=IF(Sheet1!T3="","",IF(I3<=Sheet1!$A3+Sheet1!$A11,0,(I3-Sheet1!$A3-Sheet1!$A11)*Sheet1!$C11))

(©Ò¦³ Sheet ©ó¤W­zÄæ¦ì¤¤ªº 4 ~ 6 ¦C¬Òª½±µ¤U©Ô§Y¥i)

·íµM, ¶V«á­±¶V½ÆÂø, ¦]¬°»Ý­n§PÂ_ªº¥i¯à©Ê¶V¦h...

TOP

        ÀR«ä¦Û¦b : §ïÅܦۤv¬O¦Û±Ï¡A¼vÅT§O¤H¬O±Ï¤H¡C
ªð¦^¦Cªí ¤W¤@¥DÃD