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

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

¦^´_ 20# ML089
ÂIºâ¦n¡A§Ú³£¬O¥X²{"value"¡A½Ð°Ý¬O§_¦³¨ä¥L¤½¦¡¥i¥H¨ú¥N©O?

TOP

¬O§_§ÚÀx¦s®æ®æ¦¡¦³°ÝÃD©O?§Ú¤é´Á®æ§Ú¤w¸g¥Î:¤é´Á(¥xÆW)¡A®É¶¡®æ§Ú2¸g¥Î:®É¶¡(¥xÆW)

TOP

¦^´_ 22# lesaux001

¤é´Á®æ¦¡¤£¬O°ÝÃD
®É¶¡­ì¥ý¤£¬OEXCEL®æ¦¡¡A¬O¥H0000¨Óªí¥Ü¡A­Y­×§ï«á¤½¦¡­I¶·°t¦X­×§ï¡C
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

§Ú¸Õ¹L¡A§ï¦Û­q®É¶¡¬°0000¡AD4µ²ªG³£¬Ovalue¡A¯u«Y¤j¥ó¨Æ

TOP

¯uªº¡A¥i§_±N¾ã±ø¤½¦¡¤À©î¶}¡A©ñ©ó¤£¦PÀx¦s®æ¤º¡AÁ`¥[©O?

TOP

¦^´_ 25# lesaux001

F4 =SUM(F5:F10)
F5 =--TEXT(ROUNDUP((MIN((B$5+TEXT(C$5,"0!:00")), B$3+"8:00"+(ROW(A3)-1)*0.5) - MAX((B$3+TEXT(C$3,"0!:00")), B$3-"4:00"+(ROW(A3)-1)*0.5))*24,0)*18,"[>100]!1!0!0;!0;0")
¤U©Ô¦ÜF10
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

­ø¦n·N«ä,³£«Y­ø±o

TOP

¦^´_ 27# lesaux001

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

D4
D5
F4
³o¨Ç­È¤@¼Ë¶Ü?
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 28# ML089
§Úªº¨®³õ¦¬¶Oªí.rar (28.12 KB)

·í§Ú«ö±Ò¥Î½s¿è®É¡A¤@¼Ë¥ß§YÅܦ¨"value"¡A®ö¶O§A¦a¤ß¦å²K¡A§Ú¬Q¤é©ó¤½¥q¡A«ä¦Ò¦n¤[¡A·Q¥X¤T±ø©U§£­pºâ¤½¦¡¡A´N¬O¤£ª¾¦p¦ó¾ã¦X¡A·Ð½Ð¬Ý¬Ý

TOP

¦^´_ 29# lesaux001

³Ìªñ¦£¥X°ê¤£¤Ó¦³ªÅ¦A¦^ÂÐ(¦Ó¥B¦^ÂЪºÀɮשp³£¨S¦³¥Î)¡A«áÄò»Ý­n½Ð¨ä¥L¤H¨ó§UÀ°¦£¡C
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ¡i°µ¤Hªº¶}©l¡j¨C¤@¤Ñ³£¬O¬G¤Hªº¶}©l¡A¨C¤@­Ó®É¨è³£¬O¦Û¤vªºÄµ±§¡C
ªð¦^¦Cªí ¤W¤@¥DÃD