­ã´£³¡ªL

§Q¥ÎB/CÄæ¥[Á`¤]¥i¥H, ¬°¦ó¤@©w­n¥ÎDÄæ?
¥i¤W¶ÇÀɮװѦÒ~~

­ã´£³¡ªL

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


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

­ã´£³¡ªL

µw­n¥ÎDÄæ¤å¦r¥[Á`ªº¸Ü.
°}¦C¤½¦¡
=MID(TEXT(SUM(-TEXT(LEFT(D2:D6,FIND("½c",D2:D6&"½c")-1),"0;;;!0")),";+0½c;")&TEXT(SUM(-TEXT(RIGHT(SUBSTITUTE(SUBSTITUTE(D2:D6,"²~",),"+",10^9),9),"0;;;!0")),";+0²~;"),2,29)
©Î
=SUBSTITUTE(SUBSTITUTE(TEXT(SUM(--TEXT({0,"0 "}&SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(D2:D6,"+",),"½c"," "),"²~","/9999"),"0 0/9999;;0;!0")),"#½c+0²~/9999"),"/9999",),"+0²~",)

­ã´£³¡ªL

¦^´_ 10# PJChen

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

­ã´£³¡ªL

¦^´_ 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)

­ã´£³¡ªL

¦^´_ 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·¡~~

­ã´£³¡ªL

¦^´_ 14# PJChen

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

¤U¸ü¦¸¼Æ: 6

2019-7-1 11:50

­ã´£³¡ªL

¦^´_ 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ªº"+"

­ã´£³¡ªL

¦^´_ 23# PJChen

¥Îvba¦Û­q¨ç¼Æ,
P3À³¬°21(¨ä¤¤¦³®æ¦¡ªº¥[1)
Xl0000175.rar (14.66 KB)

¤U¸ü¦¸¼Æ: 8

2020-8-4 12:11

­ã´£³¡ªL

¦^´_ 25# PJChen

§Úªºª©¥»Àɮ׶}¤£¤F,
Åý§O¤H¨Ó°µ§a~~