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

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

§Úı±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

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

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

Hello, ­ã¤j

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

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

Hello, ­ã¤j

¤F¸Ñ! ÁÂÁ§Aªº±Ð¾É.
·s¤â¤W¸ô¡A½Ð¦h¥]²[¡C

TOP

        ÀR«ä¦Û¦b : ¨Ã«D¦³¿ú¾{¬O§Ö¼Ö¡A°Ý¤ßµL·\¤ß³Ì¦w¡C
ªð¦^¦Cªí ¤W¤@¥DÃD