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

shootingstar

¦pªGA1=10730526¡B B1=24201766¡A
§Ú­n«ç»òÅýC1= INT(((1*2)+(0*4)+(7*2)+(3*0)+(0*1)+(5*7)+(2*6)+(6*6))/10)
                           ="09"
­nÅýC1¨ú¨â½X¡A¤£¨¬®É¥Î"0"¸É»ô¡AÁÂÁ¡C

p212

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

shootingstar

¦^´_ 2# p212


ÁÂÁÂp212 ªº¦^µª¡A¦³¹F¨ì§Ú­n¸É"0"ªº»Ý¨D¡A¥i¬O¦]¬°A1ªº¼Æ¦r·|¤@ª½ÅÜ°Ê¡A§Ú¤£¯à¨C¦¸A1ÅܰʮɡA³£¦b¤½¦¡¸Ì¤@­Ó¤@­Ó¼Æ¦r¥h§ï¡A§Ú·Qª¾¹Dªº¬O¦bINT³o­Ó¤½¦¡¸Ì§Ú­n«ç»ò¥h±aA1¸òB1ªºÀx¦s®æ¡AÁÂÁ¡C

p212

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

shootingstar

¦^´_ 4# p212


ÁÂÁÂp212ªº¦^ÂÐ
A1Àx¦s®æ¬O©T©wªº8½X¡A¥i¬O¨C¦¸¼Æ¦r³£·|¤£¦P¡A¥i¬OB1ªº24201766´N³£¤£·|ÅÜ°Ê
¦pªGA1=70730526
¨º»òC1=INT(((7*2)+(0*4)+(7*2)+(3*0)+(0*1)+(5*7)+(2*6)+(6*6))/10)=11
¦pªGC1=10730526
¨º»òC1=INT(((7*2)+(0*4)+(7*2)+(3*0)+(0*1)+(5*7)+(2*6)+(6*6))/10)=9

¦pªG¥H§Ú¦Û¤v¼gªº¤½¦¡¡A´N¨S¿ìªk¨ú¨â½X¡A±N­è­è±zªº¤½¦¡®M¶i¥h«á´NOK¡A¥i¬O¦]¬°A1¬OÅܰʪº¡A©Ò¥H¤~·Q»¡¯à¤£¯àª½±µ±aÀx¦s®æªº­È¡HÁÂÁ¡C

p212

¦^´_ 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(«Øij¹B¥Î_ÁôÂÃCÄæ_§Y¥i´î¤Ö¤£¥²­nªºÄæ¦ì¥X²{)

zz5151353

«Ü¦£¨S®É¶¡·Qµuªº¤½¦¡
½Ð°Ñ¦Ò C1
{=TEXT(INT(SUM(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)*MID(B1,ROW(INDIRECT("1:"&LEN(B1))),1))/10),"00")}

Hsieh

¦^´_ 5# shootingstar

=TEXT(INT(SUMPRODUCT(--MID(A1,ROW(INDIRECT("A1:A"&LEN(A1))),1),--MID(B1,ROW(INDIRECT("A1:A"&LEN(A1))),1))/10),"00")

p212

½Ð°Ý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)

p212

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