[µo°Ý] ¬Û¥[ªº¼ÐªºÀx¦s®æ¦³¦h­Ó­È

ziv976688

Sheet1
B2=IF(R2<>"",IF(MOD(J2+R2,49),MOD(J2+R2,49),49),"")
¦]¬°R2¡GX12ªº¬Y¨Ç¼ÐªºÀx¦s®æ¦³¦h­Ó­È¡A©Ò¥Hµª®×·|Åã¥Ü"#VALUE!"¡F
§Æ±æ¯à±Nµª®×§e²{¦pSheet2¡C

½Ð°Ý¡GExcel2003ª©¥»ªºSheet2!B2¨ç¼ÆÀ³¦p¦ó½s¼g¡H
ÁÂÁ¡I
¬Û¥[ªº¼ÐªºÀx¦s®æ¦³¦h­Ó­È.rar (7.73 KB)

¤U¸ü¦¸¼Æ: 4

2021-7-15 16:57

ML089

B2°}¦C¤½¦¡
=LEFT(TEXT(SUM(TEXT(MOD(J2+(0&TRIM(MID(SUBSTITUTE(R2,",","         "),1+{0,1,2,3,4}*9,9))),49),"[=0]!49")*10^{8,6,4,2,0}),"00!,00!,00!,00!,00"),IF(R2="",0,CHOOSE(1+LEN(R2)-LEN(SUBSTITUTE(R2,",",)),2,5,8,11,13)))

¥Ø«e¤½¦¡­­¨î5²Õ¼Æ¦r¦X¨Ö( 11,22,33,44,55 )
¦]¬°Microsoft Excel ·|«O¯d 15 ­Ó¦³®Ä¦ì¼Æ¡A©Ò¥H¤½¦¡³Ì¦h7²Õ¼Æ¦r¦X¨Ö¡A·íµM¤]¥i¥H©î¬°¨â²Õ¤½¦¡¨Ó¦X¨Ö¼W¥[¡C

ziv976688

¦^´_ 2# ML089
´ú¸Õ¦¨¥\
±z¤Ó¼F®`¤F¡A¤@¯ë¤½¦¡´N¥i¥H¸Ñ¨M¡C
¸U¤À·PÁ±zªº«ü¾É©MÀ°¦£

ML089

¤U¸ü (109.67 KB)

2021-7-16 10:30

­×§ïS11¡BM11¤@¨Ç¼Æ¦r¨Ó´ú¸Õ ¬Û¥[¬°49®Éªº³B²z±¡ªp

ML089

¦^´_ 3# ziv976688

«e­±¤½¦¡¦³ÂI¤p¿ù»~13¶·§ï¬°14¡A­×¥¿¦p¤U
=LEFT(TEXT(SUM(TEXT(MOD(J2+(0&TRIM(MID(SUBSTITUTE(R2,",","         "),1+{0,1,2,3,4}*9,9))),49),"[=0]!49")*10^{8,6,4,2,0}),"00!,00!,00!,00!,00"),IF(R2="",0,CHOOSE(1+LEN(R2)-LEN(SUBSTITUTE(R2,",",)),2,5,8,11,14)))

©Î±NCHOOSE§ï¬°ª½±µ­pºâ
=LEFT(TEXT(SUM(TEXT(MOD(J2+(0&TRIM(MID(SUBSTITUTE(R2,",","         "),1+{0,1,2,3,4}*9,9))),49),"[=0]!49")*10^{8,6,4,2,0}),"00!,00!,00!,00!,00"),IF(R2="",0,2+3*(LEN(R2)-LEN(SUBSTITUTE(R2,",",)))))

ziv976688

¦^´_ 5# ML089
¦A¦¸ÁÂÁª©¥Dªº­@¤ß«ü¾É©M¦h¦¸ªº¼ö¤ßÀ°¦£¡C·P®¦