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

¤ñ¹ï¨Ã§PÂ_Åã¥Ü°T®§°ÝÃD

¦^´_ 8# hcm19522


ÁÂÁ±z´£¨Ñªº¤½¦¡¼Ú!
Just do it.

TOP

¦^´_ 10# jsc0518


    =IF(COUNTA(B3,H3)=1,IF(B3="","·s¼W®Æ¥ó","§R°£®Æ¥ó"),LOOKUP((0&SUBSTITUTE(H3,".",))-(0&SUBSTITUTE(B3,".",)),{0,1,2},{"","ª©¥»¤É¯Å","§ó§ï®Æ¸¹"}))
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 12# ML089



ML089
¦b³Ì«á¤@Äæ¦ì¡A±ø¥ó¬°«á­±¤E½X¤£¤@¼Ë-->§ó§ï®Æ¸¹
¦³¿ù»~!





Noname.jpg (69.09 KB)

Noname.jpg

Just do it.

TOP

¦^´_ 13# jsc0518

§Ú´ú¸ÕOK

§A¶ÇÀɮפW¨Ó¬Ý¬Ý
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 14# ML089


§Ú³oÀɮפw¥[¤W§Aªº¤½¦¡
¦A½Ð§A¬Ý¤@¤U¡AThanks!

EXCEL_¨ç¼Æ°ÝÃD_V2.rar (34.93 KB)
Just do it.

TOP

¦^´_ 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},{"","ª©¥»¤É¯Å","§ó§ï®Æ¸¹"}))
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 16# ML089


  ´ú¸Õ¥¿±`¡AÁÂÁ§Aªº¼ö¤ß«ü¾É¡C·P®¦!
Just do it.

TOP

        ÀR«ä¦Û¦b : ÁÀ¨¥¹³¤@¦·²±¶}ªºÂAªá¡A¥~ªí¬üÄR¡A¥Í©Rµu¼È¡C
ªð¦^¦Cªí ¤W¤@¥DÃD