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

[µo°Ý] ¦p¦ó¨ú±o¤µ¤Ñ¤é´Á

¦^´_ 8# K_Wing

§Úı±o§A¥i¥H°Ñ¦Ò«e½úªº³o½g³á
    http://forum.twbts.com/viewthread.php?tid=10938

TOP

=IF(D2="","",IF(N2<>"",N2,NOW()))
µM«áExcel¿ï¶µ>¤½¦¡>¶}±Ò­«½Æ¹Bºâ
¥i¥H¦b¬YÄæ¦ì¿é¤J«á¡A¦Û°Ê¶ñ¤J¨t²Î®É¶¡
¶ñ¤Jªº­È¤£·|¦AÅÜ°Ê

TOP

¾Ú¼Ó¥D©Ò»¡,¦³³\¦h¤é´Á¶·­n­×§ï¥i¯à¤ñ¸ûÁcº¾,¤p§Ì´£¤@­Ó¸Ñ¨M¤è¦¡¬Ý¬Ý¬O§_¾A¥Î
°²³] A1¬O­n­×§ï·í¤é¤é´Á,½Ð±Ä¥Î¥¨¶°¿ý»s¥\¯à,¿ý¤U ¦bA1¿é¤J¤½¦¡ ¤Î ½Æ»sA1¨Ã"¿ï¾Ü©Ê¶K¤W­È"ªº°Ê§@©T¤Æ³o­Ó¤é´Á
(°²³]¦³ÁÙ¦³¨ä¥L®æ¤é´Á­n¤@¨Ö­×§ï,½ÐÄ~Äò¦p¤W°Ê§@¿ý»s) ,³Ì«á³]©w¦n¥¨¶°§Ö³tÁä,
¨C¦¸§@·~®É¥u¶·«ö¤U§Ö³tÁä§Y¥i (·íµM§Ñ¤F«ö´N¨S¿ìªk¤F)

TOP

        ÀR«ä¦Û¦b : ®É®É¦n¤ß´N¬O®É®É¦n¤é¡C
ªð¦^¦Cªí ¤W¤@¥DÃD