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

¬°¤°»ò·|¥X²{#VALUE!©O¡H

G6=IF(G6="","",ROUND(IF(F6*G6<1000,F6*G6+100,F6*G6),0))

TOP

=MID(R32,IF(ISERROR(FIND("¸ô",R32,6)),FIND("µó",R32,6)-2,FIND("¸ô",R32,6))-2,3)

TOP

¦^´_ 7# s10002096


    °ª¶¯¿¤¤jªÀ¶m(OR¥«ORÂí)¤¤µØ¸ô8¤§12¸¹
­n¦p¦ó§â¶m¥«Âí§ï¦¨°Ï©O¡H
¶m¥«Âí­n§ï¦¨°Ï,¥i¥Î°ò¥»¾Þ§@ªº´À´«, CTRL+H Áä,¥þ³¡¨ú¥N,¾Þ§@¤T¦¸
¤£«Øij¥Î¨ç¼Æ.
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"¶m","°Ï"),"¥«","°Ï"),"Âí","°Ï")

  ÁÙ¦³ISERROR³o­Ó¨ç¼Æ«ç»ò¨Ï¥Î§r¡A¤£ºÞ«ç»ò®M¶i¤½¦¡¸Ì³£µLªk¥¿±`¹Bºâ
  ¯u±o«Ü·P¿E§A¦^µª¤F§Ú³o»ò¦hªº°ÝÃD¡I¡I:$

  ISERROR¬O¥Î¨Ó´ú¸Õ¬O§_¨ç¼Æ¦³¿ù»~,·|¶Ç¦^TRUE ©Î FALSE,IF¨ç¼Æ®É±`·|¥Î¨ì.
  ¥i¦b½s¿è¦C¤¤§âISERROR(.........)¥Î·Æ¹«¤Ï¥Õ,¦A«öf9,´N¥i¥Hª¾¹D³o¬q¨ç¼Æªº¹B§@.

TOP

        ÀR«ä¦Û¦b : §g¤l¬°¥Ø¼Ð¡A¤p¤H¬°¥Øªº¡C
ªð¦^¦Cªí ¤W¤@¥DÃD