ML089

¦^´_ 1# jsc0518
=IF(B3=H3,"",IF(AND(B3="",H3<>""),"·s¼W®Æ¥ó",IF(AND(B3<>"",H3=""),"§R°£®Æ¥ó",IF(AND(LEFT(B3,13)=LEFT(H3,13),RIGHT(B3,1)<>RIGHT(H3,1)),"ª©¥»¤É¯Å",IF(AND(LEFT(B3,9)=LEFT(H3,9),RIGHT(B3,5)<>RIGHT(H3,5)),"§ó§ï®Æ¸¹","?")))))

ML089

¦^´_ 1# jsc0518

¦b²¤Æ¤@¤U¤½¦¡
=IF(AND(B3="",H3<>""),"·s¼W®Æ¥ó",IF(AND(B3<>"",H3=""),"§R°£®Æ¥ó",LOOKUP(,0/(LEFT(B3,{9,13,14})=LEFT(H3,{9,13,14})),{"§ó§ï®Æ¸¹","ª©¥»¤É¯Å",""})))

ML089

¦A²¤Æ

=IF(COUNTA(B3,H3)=1,IF(B3="","·s¼W®Æ¥ó","§R°£®Æ¥ó"),LOOKUP(,0/(LEFT(B3,{9,13,14})=LEFT(H3,{9,13,14})),{"§ó§ï®Æ¸¹","ª©¥»¤É¯Å",""}))

ML089

¦^´_ 8# jsc0518

½Ð°Ý --> (LEFT(B3,{9,13,14}) ³o¬qªº·N«ä¬O?
¥t¥~ { } ³o¬O¥Nªí?

{ } ¬O°}¦C¹Bºâ²Å¸¹¡ALEFT(B3,{9,13,14}) ªí¥Ü¬° LEFT(B3,9) ¡BLEFT(B3,13) ¡BLEFT(B3,14) ¤T­Ó°}¦C¶µ¥Ø

ML089

¦^´_ 10# jsc0518


    =IF(COUNTA(B3,H3)=1,IF(B3="","·s¼W®Æ¥ó","§R°£®Æ¥ó"),LOOKUP((0&SUBSTITUTE(H3,".",))-(0&SUBSTITUTE(B3,".",)),{0,1,2},{"","ª©¥»¤É¯Å","§ó§ï®Æ¸¹"}))

ML089

¦^´_ 13# jsc0518

§Ú´ú¸ÕOK

§A¶ÇÀɮפW¨Ó¬Ý¬Ý

ML089

¦^´_ 15# jsc0518

¦]¬°H9-B9¬°­t¼Æ¦Ó¿ù»~¡A¥[ABS(...)§ï¬°¥¿´N¥i¥H¡C
=IF(COUNTA(B3,H3)=1,IF(B3="","·s¼W®Æ¥ó","§R°£®Æ¥ó"),LOOKUP(ABS((0&SUBSTITUTE(H3,".",))-(0&SUBSTITUTE(B3,".",))),{0,1,2},{"","ª©¥»¤É¯Å","§ó§ï®Æ¸¹"}))