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

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

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

¦U¦ì¥ý¶i¦n,

½Ð°Ý¥Î¥H¤U¤½¦¡­pºâ¥XD2:D6ªºµª®×,¦p¦ó¦bD7¨D±oÁ`¦X387½c+24²~
D2=INT(C2/B2)&"½c"&IF(MOD(C2,B2)=0,"","+"&MOD(C2,B2)&"²~")
20190626.222213.jpg
2019-6-26 22:25

ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

§Úı±o¥u¯à¥Î¤U¦C¤è¦¡

1. ¦bEÄæ¦ì¿é¤J½c¼Æ => E2=RoundDown(C2/B2,0)
2. ¦bFÄæ¦ì¿é¤J²~¼Æ => F2=MOD(C2,B2)
3. D7=SUM(E2:E6) & "½c" & IF(SUM(F2:F6)=0,"","+" &  SUM(F2:F6) & "²~")
·s¤â¤W¸ô¡A½Ð¦h¥]²[¡C

TOP

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

ÁÂÁ§A,³o­Ó¤èªk§Ú·|,§Ú­nªº¬O¥i¥Hª½±µ¦bD7¥[Á`ªº¤èªk

TOP

ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

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

TOP

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

Hello, ­ã¤j

¥L³o­Óªº¨C¤@¦æªº¤l¼Æ»P¥À¼Æ¬O¤£¦Pªº!
¦p²Î¤@­n¦b¤@­ÓÄæ¦ì¸Ì,¦U§O¬Û°£«á, ¤S¦A¦U§O¥[Á`ªº¸Ü?
¥i¦³²[¼Æ¥i¥Î??
Thanks ~
·s¤â¤W¸ô¡A½Ð¦h¥]²[¡C

TOP

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

TOP

µ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²~",)

TOP

¦^´_ 5# hcm19522
¦^´_ 7# ¼B¤j­G
¦^´_ 9# ­ã´£³¡ªL

¦U¦ì¦n,
¸ò¤j®a¹Dºp,¤f»y¤Æ§Ú­Ì¤½¥q¤º³£·|»¡?½c+?²~,¦ý¦b¤å¥ó¤¤,§Ú³£¥ushow¥X?½c+?,¦Ó§â²~ªº³æ¦ì¬Ù²¤,§Ú¤@¤U¤£¬d,§â²~ªº³æ¦ìµ¹¥[¶i¥h¤F....¤£¦n·N«ä
§ó¥¿¦p¤U:
20190629.214644.jpg
2019-6-29 21:52

³o¬O¤@­Ó½d¨ÒÀÉ,¥­¤é¥ÎªºÀɮ׮Ƹ¹«Ü¦h,¥B¦U¦Û¤J¼Æ³£¤£¬Û¦P,©Ò¥H·|¥Î¨ì¦U¦ÛªºCÄæ/BÄæ,ºâ¥X¨C­Ó®Æ¸¹ªºÁ`½c¼Æ¤Î²~¼Æ,¦ý¦]¬°¥Î¤F¤å¦r,§Ú¤£ª¾¦p¦ó¦b¨C¤@­ÓDÄ椤ªº¼Æ¥Ø¦A¦X­p, ¤@¤è­±¤u§@»Ý­n¥Î¨ì,¥t¤@¤è­±,§Ú·Qª¾¹D¥i¤£¥i¯à¦b¤£¼W¥[Äæ¼Æªº±¡§Î¤U¥[Á`DÄæ,¬Ý¨ì¦U¦ìªº¦^ÂÐ,¯uªº²´·ú¬°¤§¤@«G,­ì¨Ó¬O¥i¥Hªº...
·Q³Â·Ð¦U¦ìÀ°¦£­×¥¿¨ç¼Æ ±N²~ªº³æ¦ì¬Ù²¤±¼¤§¥~,¥i§_¤]À°§Ú»¡©ú¤U¤½¦¡ªº¥Îªk¡I¤£¦n·N«ä§Ú¨S¥Î¹L³o¼Ëªº¤è¦¡,¦Û¤v¤S©î¸Ñ¤£¥X¨Ó,·PÁ¤j®a...
§t¤å¦r¥[Á`.rar (8.32 KB)

TOP

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