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

[µo°Ý] §t¦³¤å¦rªº¥[Á`

¦^´_ 10# PJChen

°}¦C¤½¦¡:
=MID(TEXT(SUM(INT(C2:C6/B2:B6)),"+0½c;;")&TEXT(SUM(MOD(C2:C6,B2:B6)),"+0;;"),2,29)

TOP

¥»©«³Ì«á¥Ñ PJChen ©ó 2019-6-29 23:08 ½s¿è

¦^´_ 11# ­ã´£³¡ªL

·PÁ­ã¤j,
¤½¦¡OK,
½Ð°Ý"+0½c;;"ªº·N«ä?

¥t¥~³o­Ó¤½¦¡§Ú¤]¥Î±o¨ì,·Q½Ð°Ý¦p¦ó§ï¬°¨S¦³²~ªº¥Îªk,¤è«K¤]¸Ñ»¡³o­Ó¤½¦¡¶Ü?
=MID(TEXT(SUM(-TEXT(LEFT(D2:D14,FIND("½c",D2:D14&"½c")-1),"0;;;!0")),";+0½c;")&TEXT(SUM(-TEXT(RIGHT(SUBSTITUTE(SUBSTITUTE(D2:D14,"²~",),"+",10^9),9),"0;;;!0")),";+0²~;"),2,29)

TOP

¦^´_ 12# PJChen

§¹¥þ¨S¦³"²~"¦r:
=MID(TEXT(SUM(-TEXT(LEFT(D2:D6&"X",FIND("½c",D2:D6&"X½c")-1),"0;;0;!0")),";+0½c;")&TEXT(SUM(-TEXT(RIGHT(SUBSTITUTE(D2:D6,"+",10^9),9),"0;;0;!0")),";+0;"),2,29)

§t©Î¤£§t"²~", ³£¾A¥Î:
=MID(TEXT(SUM(-TEXT(LEFT(D2:D6&"X",FIND("½c",D2:D6&"X½c")-1),"0;;;!0")),";+0½c;")&TEXT(SUM(-TEXT(RIGHT(SUBSTITUTE(SUBSTITUTE(D2:D6,"²~",),"+",10^9),9),"0;;;!0")),";+0;"),2,29)

TOP

¦^´_ 13# ­ã´£³¡ªL
½Ð°Ý­ã¤j,

³o¤G­Ó¤½¦¡ ·íDÄæ¨ä¤¤¤@®æÅã¥Ü0©ÎªÅ¥Õ®É,¥[Á`·|¥X²{¤£¦P±¡§Î?
§¹¥þ¨S¦³"²~"¦r: ·íDÄæ¨ä¤¤¤@®æÅã¥Ü0 ©ÎªÅ¥Õ ®É,¥[Á`³£¥¿±`
=MID(TEXT(SUM(-TEXT(LEFT(D2:D6&"X",FIND("½c",D2:D6&"X½c")-1),"0;;0;!0")),";+0½c;")&TEXT(SUM(-TEXT(RIGHT(SUBSTITUTE(D2:D6,"+",10^9),9),"0;;0;!0")),";+0;"),2,29)

§t©Î¤£§t"²~", ³£¾A¥Î: ·íDÄæ¨ä¤¤¤@®æÅã¥ÜªÅ¥Õ®É,¥[Á`¥¿±`,¦ý·íDÄæ¨ä¤¤¤@®æÅã¥Ü 0®É,¥[Á`´NÅܦ¨#VALUE!,
=MID(TEXT(SUM(-TEXT(LEFT(D2:D6&"X",FIND("½c",D2:D6&"X½c")-1),"0;;;!0")),";+0½c;")&TEXT(SUM(-TEXT(RIGHT(SUBSTITUTE(SUBSTITUTE(D2:D6,"²~",),"+",10^9),9),"0;;;!0")),";+0;"),2,29)
¥t¥~¡A§Ú«Ü·Q¤F¸Ñ³o¤G­Ó¤½¦¡ªº·N«ä¡A¥i§_À°­Ó¦£µù¸Ñ¤@¤U?

TOP

¦^´_ 9# ­ã´£³¡ªL

Hello, ­ã¤j

ÁÂÁ§Aªº±Ð¾É, ¤S¾Ç¨ì¤@½Ò¤F!!
Thanks ~
·s¤â¤W¸ô¡A½Ð¦h¥]²[¡C

TOP

¦^´_ 14# PJChen


§t©Î¤£§t"²~", ³£¾A¥Î: ·íDÄæ¨ä¤¤¤@®æÅã¥ÜªÅ¥Õ®É,¥[Á`¥¿±`,¦ý·íDÄæ¨ä¤¤¤@®æÅã¥Ü 0®É,¥[Á`´NÅܦ¨#VALUE!,
=MID(TEXT(SUM(-TEXT(LEFT(D2:D6&"X",FIND("½c",D2:D6&"X½c")-1),"0;;0;!0")),";+0½c;")&TEXT(SUM(-TEXT(RIGHT(SUBSTITUTE(SUBSTITUTE(D2:D6,"²~",),"+",10^9),9),"0;;0;!0")),";+0;"),2,29)


¥t¥~¡A§Ú«Ü·Q¤F¸Ñ³o¤G­Ó¤½¦¡ªº·N«ä¡A¥i§_À°­Ó¦£µù¸Ñ¤@¤U?
__³o....¦³ÂI§xÃø....§Þ¥©°ÝÃD, ¶·¸gÅç²Ö¿n, ­nÁ¿¤]Á¿¤£²M·¡~~

TOP

¦^´_ 14# PJChen

¤À¸Ñ°Ê§@, ¦Û¦æ¥h¬ã¨s:
Xl0000581.rar (7.47 KB)

TOP

Hello, PJ

§Úı±o­ã¤jªº³o­Ó¤½¦¡¤ñ¸û²³æ, §Ú¤]µy·L§ï¤F¤@¤U,MIDªº¤½¦¡¤£¥ÎÀ³¥i¥H.
¨ä¾l¦U§O¤½¦¡©î¥X¨Ó, ´N¤ñ¸û¦n²z¸Ñ¤F!

PS. ¦]¬°INT¦³4±Ë5¤Jªº°ÝÃD, ©Ò¥H¤ñ¸û«Øij¥ÎµL±ø¥ó±Ë¥h.

=TEXT(SUM(ROUNDDOWN(C2:C6/B2:B6,0)),"0½c;;")&TEXT(SUM(MOD(C2:C6,B2:B6)),"+0;;")

Hello, ­ã¤j

½Ð±Ð¤@¤UText¤½¦¡¸Ì, ³£¦³";;"³o­Óµ²§À, ¨ä¥Î·N¬°¦ó?
¦A½Ð¤£§[½ç±Ð! Thanks ~
·s¤â¤W¸ô¡A½Ð¦h¥]²[¡C

TOP

¥»©«³Ì«á¥Ñ ­ã´£³¡ªL ©ó 2019-7-1 16:45 ½s¿è

¦^´_ 18# ¼B¤j­G


TEXT(??,"¤j¤_0;¤p¤_0;µ¥¤_0;¤å¦r")
¨Ì·Ó¨º¥|­Ó«¬ºA¦U¦Û³]©w­nÅã¥Üªº®æ¦¡,
;;; ¤¤¶¡¬Ù²¤, ªí¥ÜÅã¥ÜªÅ¥Õ
TEXT(??,"0;;;")  > °£¤F¤j¤_0¥~, ¨ä¾l³£Åã¥ÜªÅ¥Õ

¥ÎMID, ¬O¥i¯à¥[Á`«á¥u¦³"½c", ©Î¥u¦³"²~", ·|¯d«e«á¦h¾lªº"+"

TOP

¦^´_ 19# ­ã´£³¡ªL

ÁÂÁ­ã¤j,
³o¼Ë¸Ñ»¡¤@¤U,Á`¤ñ½M¤lºN¶H¨Ó±o±j...

TOP

        ÀR«ä¦Û¦b : §g¤l¬°¥Ø¼Ð¡A¤p¤H¬°¥Øªº¡C
ªð¦^¦Cªí ¤W¤@¥DÃD