- ©«¤l
- 618
- ¥DÃD
- 17
- ºëµØ
- 0
- ¿n¤À
- 663
- ÂI¦W
- 1
- §@·~¨t²Î
- WINDOWS 7
- ³nÅ骩¥»
- OFFICE 2013
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Pingtung
- µù¥U®É¶¡
- 2011-9-2
- ³Ì«áµn¿ý
- 2024-7-5
|
¥»©«³Ì«á¥Ñ 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¡AY¹j¤é¶}ÀɸӤé´Á¥ç¤§²§°Ê¡A¥i§_µ¹¤©¤é´Á¸ê®ÆÄæ¦ì«·s³]©w¤½¦¡¡AÁÂÁ¡I |
|