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

[µo°Ý] ®É¯²°±¨®³õ¦¬¶OexceL°ÝÃD¡A¨D±Ð

¦^´_ 10# ML089
§Ú¥´¶}§Aµ¹§Úªº"°±¨®¶O¥Î­pºâ"ÀÉ¡A¥´¶}«á"D4"¥X²{value¡A½Ð°Ý¬O¤£¬Ooffice°ÝÃD?ÁÂÁ§A¦h¦¸À°§U¡A±Ï±Ï§Ú¡AÁÂ

°±¨®¶O¥Î­pºâ.rar (10.11 KB)

TOP

¦^´_ 10# ML089
ÁÂÁ¡A§Úµ¹§A¹Ï¤ù °±¨®¶O¥Î­pºâ.rar (302 KB) ¡AÁÂÁ§A¡A·íµM¡A§A¥i¥H§ó§ï§Ú¤º¸Ì®æ¦¡¡A§Ú¯u«Y¬°¤F¤u§@¡A§Æ±æ§AÀ°¨ì§Ú¡AÁÂ

TOP

¦^´_ 12# lesaux001

°±¨®¶O¥Î­pºâ2003.rar (10.14 KB)
¦s¬°2003ª©¥»¡A§A¦b¶}¬Ý¬Ý¡C

§A±H¨ÓªºÀɮ׶}°_¨Ó¡A¶}±Ò½s¿è´NOK¡A¨S¦³²§¼Ë¡C
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 13# ML089
§A¦n¡A·í§Ú«ö"±Ò¥Î½s¿è"«á¡AD4®æ­ì¥»Åã¥Ü¤§136¤¸¡A¥ß§YÅܦ^"value"¡A½Ð°Ý¬O§_"Àx¦s®æ®æ¦¡"¥X²{°ÝÃD?(ªþ¹Ï)

TOP

¦^´_ 14# lesaux001

³o§Ú´N¤£À´¤F? ¬O§AEXCEL³]©w¤W¦³¤£¦P¶Ü?

¿ï¶µ - ¤½¦¡ ¤¤¬Ý¬Ý¦³¦ó¤£¦P


   
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

§A¦n¡A¦hÁ§A¤£Â_À°§Ú¡A§Ú©M§A³]©w¤@¼Ë¡A¦ý¯uªº¶}¤£¨ì¡A§Ú¦A¬ã¨s¤U¡A­ü¡AÁÂÁ§AÀ°§U!

TOP

¦^´_ 16# lesaux001 §Ú¤w¦w¸Ëwindows office 2003,³£¥X²{"value"

TOP

¦^´_ 13# ML089

§A¤W¶Çªþø¬B5ªº¤½¦¡  =SUMPRODUCT(--TEXT(ROUNDUP(FREQUENCY(TEXT(C3,"0!:00")*24*60+ROW(INDIRECT("1:"&INT((B5+TEXT(C5,"0!:00") - (B3+TEXT(C3,"0!:00")))*24*60))),"8:00"*24*60+(ROW(1:9)-1)*12*60)/60,0)*18,"[>100]!1!0!0;0"))
=«e­±¦h¤F¤@­ÓªÅ®æ¦¨¬°¤å¦r¤F,Åã¥Ü¤½¦¡ªº¤º®e
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

¦^´_ 18# GBKEE °±¨®¶O¥Î­pºâ.rar (10.11 KB)
ÁÂÁ¦U¦ìÀ°§U¡AD4®æ³£¬O¥X²{"#value!"¡A¯u¬OµL¿ìªk

TOP

¦^´_ 18# GBKEE

D4¤½¦¡§Ú¦Û¤v­«·s¤U¸ü«á­«¶}¤]¨S¦³°ÝÃD¡A«ç»ò«e­±·|¦³ªÅ®æ? µM¹D§Ú­è¦w¸Ëªº EXCEL 2016 ¤ô¤g¤£ªA¶Ü?
½Ð°Ý GBKEE¶W¯Åª©¥D D4¤½¦¡´ú¸ÕOK¡A¥i§_´ú¸ÕOK¦A¤W¶Ç¡C
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ¯u¥¿ªº·R¤ß¡A¬O·ÓÅU¦n¦Û¤vªº³oÁû¤ß¡C
ªð¦^¦Cªí ¤W¤@¥DÃD