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

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

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

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)

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
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

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

TOP

¥»©«³Ì«á¥Ñ ML089 ©ó 2021-7-16 10:33 ½s¿è

¿Ã¹õÂ^¨úµe­± 2021-07-16 102942.jpg
2021-7-16 10:30


­×§ïS11¡BM11¤@¨Ç¼Æ¦r¨Ó´ú¸Õ ¬Û¥[¬°49®Éªº³B²z±¡ªp
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 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,",",)))))
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

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

TOP

        ÀR«ä¦Û¦b : ¯àµ½¥Î®É¶¡ªº¤H¡A¥²¯à´x´¤¦Û¤v§V¤Oªº¤è¦V¡C
ªð¦^¦Cªí ¤W¤@¥DÃD