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

[µo°Ý] ¤½¦¡«ç»ò¼g

¥»©«³Ì«á¥Ñ p212 ©ó 2013-1-3 13:52 ½s¿è

¦^´_ 1# shootingstar
¨Ñ±z°Ñ¦Ò¡A½Ð¸Õ¸Õ¬Ý¡I
=CONCATENATE(REPT("0",2-LEN(INT(((1*2)+(0*4)+(7*2)+(3*0)+(0*1)+(5*7)+(2*6)+(6*6))/10))),INT(((1*2)+(0*4)+(7*2)+(3*0)+(0*1)+(5*7)+(2*6)+(6*6))/10))

»¡©ú¡GÂŦr¡u2¡v¡AªíÅã¥Ü¡u¤G¡v¦ì¼Æ¡A­Ó¦ì¼ÆªÌ¨ä¤Q¦ì¼Æ¥H"0"¶ñ¸É¡A¦p"09"¡C

TOP

¥»©«³Ì«á¥Ñ p212 ©ó 2013-1-3 14:05 ½s¿è

¦^´_ 3# shootingstar

1.½Ð°ÝA1Àx¦s®æªº¼Æ¦r¨C¦¸¦ì½X¬Ò¬Û¦P?
2.©³½u¼Ð¥Ü³¡¥÷¬°©T©w?¥i§_±N±zªº°ÝÃD¦A²M·¡¦a´y­z¤@¤U?
INT(((1*2)+(0*4)+(7*2)+(3*0)+(0*1)+(5*7)+(2*6)+(6*6))/10)

TOP

¥»©«³Ì«á¥Ñ p212 ©ó 2013-1-3 15:18 ½s¿è

¦^´_ 5# shootingstar
1.½Ð±N±zC1Àx¦s®æ­ì¦³ªº¤½¦¡=INT(((7*2)+(0*4)+(7*2)+(3*0)+(0*1)+(5*7)+(2*6)+(6*6))/10)
ª½±µ¥H¤å¦r¨ç¼Æ_LEFT¡BMID¡BRIGHT§ï¬°¤U¦C¤½¦¡§Y¥i
=INT(((LEFT(A1,1)*2)+(MID(A1,2,1)*4)+(MID(A1,3,1)*2)+(MID(A1,4,1)*0)+(MID(A1,5,1)*1)+(MID(A1,6,1)*7)+(MID(A1,7,1)*6)+(RIGHT(A1,1)*6))/10)
2.¬°§K¤½¦¡½ÆÂø¡A½Ð¥t©óD1Àx¦s®æ¼g¤J=CONCATENATE(REPT("0",2-LEN(C1)),C1)¥HÅã¥Ü±z©Ò­nªºµª®×¡C(«ØÄ³¹B¥Î_ÁôÂÃCÄæ_§Y¥i´î¤Ö¤£¥²­nªºÄæ¦ì¥X²{)

TOP

½Ð°ÝHsiehª©¤j¡A¬°¦ó¤½¦¡
=TEXT(INT(SUMPRODUCT(--MID(A1,ROW(INDIRECT("A1:A"&LEN(A1))),1),--MID(B1,ROW(INDIRECT("A1:A"&LEN(A1))),1))/10),"00")
¤£¥i¨Ï¥Î? (¥HA1Àx¦s®æ¿é¤J70730526¡Aµª®×¬°0¡A¨Ã¤£¬O11¡C)

TOP

Hsiehª©¤j¡G¹ï¤£°_¡I¬O§Ú²¨©¿¡C¤½¦¡º}«G¡BµL»~¡AÁÂÁ¡I

TOP

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