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

[µo°Ý] ³]©w®æ¦¡¤Æªº±ø¥ó

[µo°Ý] ³]©w®æ¦¡¤Æªº±ø¥ó

¦A½Ð°Ý¤j¤j­Ì:

³]©w®æ¦¡¤Æªº±ø¥ó°ÝÃD
1. D3¡Ø¤µ¤Ñ-1®É,D3Àx¦s®æ¶ñº¡¬õ¦â
2. D3¤¶©ó¤C¤Ñ¤º, D3Àx¦s®æ¶ñº¡¶À¦â
3. E3¡ØD3, D3Àx¦s®æ¶ñº¡ºñ¦â, E3ªº­È¤£¥i¬°0
4. ­YG3¬°1©Î2, «hA3~F3¦rÅé¥þ¤Ï¦Ç¦â, ¥BA3~G3Àx¦s®æ¥þ¬°µL¶ñº¡

¥t¥~Ãö©ó¤@¨Ç±`¥Î¨ç¼Æ, ¦pif, indexµ¥µ¥, ±`±`§Ú¨Ï¥Îofficeªº¨ç¼Æ¸ÑÄÀ³£ÁÙ¬OµLªk¬ÝÀ´,
½Ð°Ý¬O¤£¬O¦³¤°»ò®Ñ©Î¬O«Øij¥i¥H¦h¥[½m²ß¥H¼ô½m³o¨Ç¨ç¼Æ?
ÁÂÁ¦U¦ì!

³]©w®æ¦¡¤Æ.rar (3.83 KB)

D3¤¶©ó¤C¤Ñ¤º, D3Àx¦s®æ¶ñº¡¶À¦â
ªº·N«ä¬O>TODAY()-7¥B<TODAY()+7¶Ü?
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

D3¤¶©ó¤C¤Ñ¤º, D3Àx¦s®æ¶ñº¡¶À¦â
®æ¦¡¤Æ±ø¥óÀ³¸Ó¬O¤¶©ó  "=today+7"  ¥B "=today"
À³¸Ó¬O³o¼Ë,§ÚÅ޿観ÂI¶Ã¤F

TOP

¦^´_ 3# ClareWu


   
³]©w®æ¦¡¤Æ.rar (146.34 KB)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

2007¥i¥H³]©w¶W¹L3²Õ®æ¦¡¤Æ±ø¥ó¶Ü?
§ÚÁÙ¦b¨Ï¥Î2003
¥u¯à³]©w3ºØ±ø¥ó

TOP

¦b Excel 2010 ¤¤¡A³]©w®æ¦¡¤Æªº±ø¥ó³Ì¦h¥i¥H¥]§t¤»¤Q¥|­Ó±ø¥ó¡A¦ý¬O¦b Excel 97-2003 ¤¤¡A¥u·|¬Ý¨£«e¤T­Ó±ø¥ó¡C
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

·s¤B­ì¥ý¤£À´¦P®É³B²z[1]¤Î[2]ªº±ø¥ó¡AÁÙ»~·|·|¦³½Ä¬ð¡A
Ū¹LHsieh¤j¤jªº¥Ü½d«á¡A¤~¾Ç·|¦p¦¹§@ªk¡I

TOP

Á¤j¤j¯u¬O¤Ó»Å,½Ð°Ý±z¹ï©ó§Ú³o¼Ëªº·s¤â¨Ï¥Î¨ç¼Æ,¬O§_¦³¤°»ò«Øij¥i¥HÅý§Ú¼ô±x¨ç¼Æ¨Ï¥Î©O?

TOP

¯à°÷±NExcel°ò¥»¥\¯à¹B¥Î±o·í,¤]¬O¬Û·íÀb¤H
ÀH«á°¨¤W¦Û¤v½m²ß~Æg
·PÁÂ¥DÃD»P¦Ñ®v¤j®aªº¦^À³~¨ü¥Î¤F
¶}¤ß¾Ç²ß,¾Ç²ß«Ü¶}¤ß

TOP

¥»©«³Ì«á¥Ñ gn00487767 ©ó 2012-2-9 20:09 ½s¿è

¦^´_ 4# Hsieh


½Ð°ÝHsieh ¤j¤j
¦pªG2003ª© ­n³]©w ¦~ÄÖ¤p©ó20¥H¤UÅã¥Üºñ¦â & ¦~ÄÖ¤j©ó80¥H¤WÅã¥Ü¬õ¦â ¯à°÷«ç»ò°µ©O?
(³]©w®æ¦¡¤Æªº±ø¥ó©M³]©wÀx¦s®æ®æ¦¡¤À§O«ç»ò°µ ©Î¬O¨ä¤¤¤@ºØ¬Ò¥i)
ÁÙ¬O»¡2003ª©ªº¹J¨ì¦~ÄÖªº°ÝÃD³£¤£·Ç½T?
·Ð½Ð¤j¤j½ç±ÐÅo^^

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡¦pÆp¥Û¡j®É¶¡¹ï¤@­Ó¦³´¼¼zªº¤H¦Ó¨¥¡A´N¦pÆp¥Û¯ë¬Ã¶Q¡F¦ý¹ï·M¤H¨Ó»¡¡A«o¹³¬O¤@§âªd¤g¡A¤@ÂI»ù­È¤]¨S¦³¡C
ªð¦^¦Cªí ¤W¤@¥DÃD