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

¼Æ¦r¸É¹s

¼Æ¦r¸É¹s

¥»©«³Ì«á¥Ñ yc1031 ©ó 2012-2-1 15:21 ½s¿è

¦U¦ì¦n,

·Q½Ð±Ð, §Ú¦b¥Î¼Æ¦r­pºâ©M¸É¹s®É, ²Ä¤@±Æ 3.6 , 2.4, 1.8 ³£¦¨¥\¤F, ¦ý²Ä¤G±Æªº10, «o¥¢±Ñ¤F, ¨ç¼Æ¬O¿ù¦b­þ¸Ì©O
¸É¹s.JPG

¦^´_ 1# yc1031

REPT("0",2-LEN(B2*100/30))
¨ä¤¤2-LEN(B2*100/30)À³>=0

­YB2=10
2-LEN(B2*100/30)=2-LEN(33.333333)   ³y¦¨¿ù»~

TOP

¦^´_ 2# register313


    §Ú©ú¥Õ¤F!  §Ú­è¥Î¤F =REPT("0",2-LEN(ROUND(B2*100/30,0)))&(ROUND(B2*100/30,0))
´Nok¤F, ¦A¦¸ÁÂÁ±zªºÀ°¦£ :)

TOP

¦^´_ 3# yc1031


    ­n¸É¹sªº¦a¤è=>Àx¦s®æ¦¡=> 00

TOP

½Ð°Ý§Ú¦b½m²ß³o­Ó°ÝÃD¬O¥X²{¤F¤@­Ó°ÝÃD
¦b¤T¤Qªº¦a¤è´N·|¥X²{¿ù»~
tests.jpg
excel¾Ç²ß¤¤!¿v¥X¹Ú·Q
https://www.youtube.com/channel/UCPAiRNsHX3k_omp0YDgfDiA

TOP

¦^´_ 5# kkooo15

=REPT("0",2-LEN(ROUND(B2*100/30,0)))&(ROUND(B2*100/30,0))

REPT("0",2-LEN(ROUND(B2*100/30,0)))
­«ÂЦr¤¸ : "0"
­«ÂЦ¸¼Æ : 2-LEN(ROUND(B2*100/30,0))  À³>=0

­YB2=30
2-LEN(ROUND(B2*100/30,0))=2-LEN(ROUND(30*100/30,0))= 2-LEN(ROUND(100,0)=2-LEN(100)=2-3=-1   ­«ÂÐ-1¦¸   ³y¦¨¿ù»~

TOP

        ÀR«ä¦Û¦b : ¤@¥y·Å·xªº¸Ü¡A´N¹³©¹§O¤H¨­¤WÅx­»¤ô¡A¦Û¤v·|ªg¨ì¨â¤Tºw¡C
ªð¦^¦Cªí ¤W¤@¥DÃD