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

[µo°Ý] ®w¦s­pºâ»P¤é´ÁÅã¥Ü

[µo°Ý] ®w¦s­pºâ»P¤é´ÁÅã¥Ü

¦U¦ìEXCEL¯«¤H:
·Q½Ð±Ð¡A¥Ø«e¦bJ4Äæ¦ì¤w³]¦n¥X¤J®w¤Î¥X¤J¼Æ¶q¤§µ²¾l¤½¦¡(»P®w¦s¼Æ¶q¦X­p) ¤½¦¡:IF(I4="","",SUM(J3,I4*IF(H4="¤J®w",1,-1))+G4)
¦ý­Y§Ú¦b¥X¤J®w¤Î¥X¤J¼Æ¶q¤§Äæ¦ì­Y¥¼¶ñ¤J¥ô¦ó¼Æ¦r¡A«h¸ÓÄæ¦ìJ4¨Ã¤£·|Åã¥Ü¥ô¦ó¼Æ¦r

Q1:À³¸Ó¦p¦ó¦bH4¤ÎI4¥¼¶ñ¤J¼Æ¦rª¬ªp¤U¡AJ4¤§Äæ¦ìª½±µÅã¥Ü½LÂI¼Æ¶q(G4)¡F­YH4¤ÎI4Äæ¦ì¦³±a¤J¼Æ¦r«h»PG4¬Û¥[´î¡C

Q2:¦bA¡BBÄæ¦ì¤é´Á³¡¤À(©Î¬O³æ¤@¤é´ÁÄæ¦ì)¡A¬O§_¥i¥H©óC~JÄæ¦ì¦³±a¤J¼Æ¦r©Î¤å¦rªº±¡ªp¤U¤~Åã¥Ü"·í¤Ñ¤é´Á"¡A¤Ï¤§«h§K¡C

¤p§Ì¤~²¨¾Ç²L¡AÀµ½Ð¦U¦ì¯«¤H«üÂI°g¬z

·P®¦
                  


¥»©«³Ì«á¥Ñ p212 ©ó 2014-6-12 09:05 ½s¿è

¦^´_ 1# ¤T½ü¯}­·
Q1¡G¦bH4¤ÎI4¥¼¶ñ¤J¼Æ¦rª¬ªp¤U¡AJ4¤§Äæ¦ìª½±µÅã¥Ü½LÂI¼Æ¶q(G4)¡A
Àx¦s®æJ4¤½¦¡«Øij­×§ï¬° =IF((H4="")*(I4=""),G4,SUM(J3,I4*IF(H4="¤J®w",1,-1))+G4)
Q2¡G°²³]BÄ欰¤é´Á¡A©óC~IÄæ¦ì¦³±a¤J¼Æ¦r©Î¤å¦rªº±¡ªp¤U¤~Åã¥Ü¡u·í¤Ñ¤é´Á¡v
Àx¦s®æB4«Øij¤½¦¡=IF(PHONETIC(C4:I4)="","",TODAY())  [ ¦]Äæ¦ìC~I¥þ¬°¤â°Ê¿é¤J¸ê®Æ¡A¬G±Ä¥ÎPHONETIC¨ç¼Æ§PÂ_¡C]
½Ð°Ñ¦Ò¡I
µù¡G½Ð°Ý¨C¤@µ§¸ê®Æªº¤é´Á¬Ò¬Û¦P¡H¤W¦C¤½¦¡¨Ì±zªº»Ý¨D--Åã¥Ü¡u·í¤Ñ¤é´Á¡v³]©w¡A­Y¹j¤é¶}ÀɸӤé´Á¥ç¤§²§°Ê¡A¥i§_µ¹¤©¤é´Á¸ê®ÆÄæ¦ì­«·s³]©w¤½¦¡¡AÁÂÁ¡I

TOP

¦^´_ 2# p212

¤£¦n·N«ä~
À³¸Ó¬O»¡ ­Y©ó6/12  KEY¤J²Ä¤@µ§¸ê®Æ «hBÄd¦Û°Ê¥N¥X·í¤Ñ¤é´Á

­Y6/13¦A¦¸ KEY¤J¸ê®Æ«h6/12¤§¤é´Á¬O§_¥i¥H¤£ÅÜ(¨ÌµM¬°KEY¤J¸ê®Æ¤§¤é´Á6/12)

·PÁ¤j¤j«ü¾É~~~

TOP

¥»©«³Ì«á¥Ñ p212 ©ó 2014-6-12 12:39 ½s¿è

¦^´_ 3# ¤T½ü¯}­·
¥H±z¤W­zªºª¬ªp¡ABÄ檺¡u¤é´Á¡v¸ê®Æ¥i¥H¤£»Ý¨Ï¥Î¨ç¼Æ±a¤J¡A«ØÀɮɥH¤â°Ê¤è¦¡¿é¤J¤£¬O¤ñ¸û¤è«K©M·Ç½T¡H
­n¤£­nªþ¤W½d¨ÒÀÉ¡A¦nÅý¤j¹Ù¨à¤@°_¬ã¨s¡H¡I

TOP

¦^´_ 4# p212
¦]¦pªþ¥ó©Ò¥Ü¡ABÄd¦ì¬O¹w­p¥Î¨Ó¥H¤Gºû±ø½X¨ê¤J¤§²£«~¸ê®Æ¡A¬G¬°Â²¤Æ¨Ï¥Î¤H­û¾Þ§@¡A¬G§Æ±æ¤â¶ñ³¡¤À¯àºÉ¶q²¤Æ¡C


­Ü®w¬[¤W²MÂI.zip (91.12 KB)

TOP

¦^´_ 5# ¤T½ü¯}­·

¦U¦ì¯«¤H¤j¤j:

                       ·Q½Ð±Ð¡A¦]¥Ø«e½LÂI¼Æ¶q¬O¨Ì¸ê®Æ®w(2F¡B3F)©Ò¥N¥X
­Õ­Y6/12¿é¤J¹Ï­±½s¸¹22207-AA¸Ó¤@®Æ¸¹¡A¨t²Î¦Û°Ê¥Ñ¸ê®Æ®w¥N¥X¥Ø«e½LÂI¼Æ¶q¬°24¡C­Y¦A©ó"¥X¤J®w"Äæ¦ì(G2)¶ñ¤J"¤J®w"¡A"¤J¥X¼Æ¶q"Äæ¦ì(H2)¶ñ¤J¼Æ¶q¬°2¡A"µ²¾l"Äæ¦ì(I2)¦Û°Ê¥N¥X"26"

Q1:­Y6/13¦A¦¸±a¤J¹Ï­±½s¸¹¬Û¦P¤§22207-AA®Æ¸¹¡AÀ³¸Ó¦p¦ó¦b"½LÂI¼Æ¶q"¤§Äæ¦ìÅã¥Ü6/12©Ò³Ì«áµ²¾l¤§¼Æ¶q(»P¸ê®Æ®w§@¬Û¥[´î°Ê§@)??

[attach]18479[/attach]

TOP

        ÀR«ä¦Û¦b : ¬Ý§O¤H¤£¶¶²´¡A¬O¦Û¤v­×¾i¤£°÷¡C
ªð¦^¦Cªí ¤W¤@¥DÃD