- ©«¤l
- 618
- ¥DÃD
- 17
- ºëµØ
- 0
- ¿n¤À
- 663
- ÂI¦W
- 1
- §@·~¨t²Î
- WINDOWS 7
- ³nÅ骩¥»
- OFFICE 2013
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Pingtung
- µù¥U®É¶¡
- 2011-9-2
- ³Ì«áµn¿ý
- 2025-1-2
  
|
¥»©«³Ì«á¥Ñ 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²{) |
|