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

[µo°Ý] Àx¦s®æ¦¡³]©w

[µo°Ý] Àx¦s®æ¦¡³]©w

½Ð°ÝÄæ¦ì¤¤ªº¼Æ¦r
Äæ¦ìA / Äæ¦ìB=Äæ¦ìC
Äæ¦ìCªº¼Æ¦r(»Ý¥Î¤d¤À¦ì,²Å¸¹)¦pªG¦³¤p¼ÆÂI®ÉÄæ¦ì¦p¦ó³]©w¦Û°Ê¶ñº¡ÃC¦â©O?

¸Õ¸Õ¬Ý
³]©w®æ¦¡¤Æªº±ø¥ó
·s¼W³W«h
¨Ï¥Î¤½¦¡¨Ó¨M©w­n®æ¦¡¤Æ¨º¨ÇÀx¦s®æ
¿é¤J¤½¦¡=MOD(A1,B1)<>0
®æ¦¡
¶ñº¡ ¿ï§A·Q­n¶ñº¡ªºÃC¦â

TOP

¥»©«³Ì«á¥Ñ h99949 ©ó 2015-1-20 08:55 ½s¿è

¦^´_ 2# fantersy

ÁÂÁÂfantersyªº«ü¾É

¥t¥~½Ð°ÝC1ªº®æ¦¡­n¦p¦ó³]©w
A1/B1=C1

10000/2=5,000
10000/3=3,333.333

C1=¾ã¼Æ®É¤£Åã¥Ü¤p¼ÆÂI,¨Ï¥Î¤d¤À¦ì,²Å¸¹
C1=¦³¤p¼ÆÂI®ÉÅã¥Ü¤p¼ÆÂI,¨Ï¥Î¤d¤À¦ì,²Å¸¹

TOP

¥»©«³Ì«á¥Ñ fantersy ©ó 2015-1-20 11:24 ½s¿è

¦^´_ 5# h99949


    ¦b§AªºC1ª½±µ¿é¤J¤½¦¡
IF(MOD(A1,A2)=0,TEXT(A1/A2,"0,000"),TEXT(A1/A2,"0,000.0"))
¨ä¤¤
TEXT(A1/A2,"0,000.0")
¥Ø«e§Ú¼gªº¬O¤p¼ÆÂI¤@¦ì
­n¬Ý¤j¤j­n¤p¼ÆÂI´X¦ì
´N¦b«á­±¦h´X­Ó0´N¦n¤F
½Ð¸Õ¸Õ¬Ý!!

TOP

¦^´_ 6# fantersy


ÁÂÁÂfantersyªº«ü¾É
¦ý¦pªG¬O100/2·|Åã¥Ü¦¨0,050
­n¦p¦ó±N«e­±ªº0¤£Åã¥Ü?

TOP

¦^´_ 6# h99949


    ¸ÕµÛ±N¤½¦¡§ï¦¨
=IF(MOD(A1,A2)=0,TEXT(A1/A2,"#,#"),TEXT(A1/A2,"#,#.0"))
¨ä¤¤TEXT(A1/A2,"#,#.0")
¬°¤p¼ÆÂI¤@¦ì
¤j¤j­n¤p¼ÆÂI´X¦ì´N¦Û¤v­×§ï´X­Ó0¶i¥h´N¦n
©êºp~±ø¥ó¨S§Ë²M·¡...><

TOP

¦^´_ 7# fantersy


  ¦pªGÄæ¦ì³£¨S¿é¤J®ÉC1·|Åܦ¨#DIV/0!
¦p¦ó±N#DIV/0!Åܦ¨ªÅ¥Õ

TOP

¥»©«³Ì«á¥Ñ fantersy ©ó 2015-1-20 14:17 ½s¿è

¦^´_ 8# h99949


    «z~©êºp
±ø¥ó¯uªº«Ü¦h....¹ï§Ú¨Ó»¡.....
¤½¦¡§ï¦¨
=IF(OR(A1="",B1=""),"",IF(MOD(A1,B1)=0,TEXT(A1/B1,"#,#"),TEXT(A1/B1,"#,#.0")))

¦pªGA1¤ÎB1¨ä¤¤¤@­Ó¬O¨S¦³¿é¤Jªº C1´N·|¬OªÅ¥Õ....»Ý­nA1¸òB1³£¦³¿é¤JC1¤~·|Åã¥Ü....

­è­è¦n¹³³£¼g¿ù¤F
A2¨ä¹ê¬OB1....

ÁÙ¦³¶Ü.........

TOP

¦^´_ 9# fantersy


¤w¸g¥þ³¡¸Ñ¨M¤F:)
ÁÂÁÂfantersyªº«ü¾É

TOP

=IF(B1,TEXT(A1/B1,"#,##0"&IF(MOD(A1,B1),".?????","")),"")

¾ã¼Æ, ¤d¤À¦ì, µL¤p¼ÆÂI
«D¾ã¼Æ, ¤d¤À¦ì, ¦³´X¦ì¤p¼ÆÅã¥Ü´X¦ì, ³Ì¦h5¦ì, ¥i¦Û¦æ½Õ¾ã"?"­Ó¼Æ~

TOP

        ÀR«ä¦Û¦b : ¤H¨ÆªºÁ}Ãø»PµZ¿i¡A´N¬O¤@ºØ¦ÒÅç¡C
ªð¦^¦Cªí ¤W¤@¥DÃD