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

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

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

¬°¤°»ò·|¥X²{#VALUE!,­n«ç»ò¸Ñ¨M©O¡H

­qÁʤé³øªí.rar (8.16 KB)

¦^´_ 1# s10002096


¸Õ¸Õ

I6=IF(IF(F6*G6<1000,F6*G6+100,F6*G6)=100,"",IF(F6*G6<1000,F6*G6+100,F6*G6)) ¦V¤U½Æ»s
¥u¬°¾Ç²ß©Ò¥Hµo°Ý

TOP

¦^´_ 2# binargoo


    ¤£¦n·N«ä¡A§A»¡ªº³o­Ó§Úª¾¹D¡A§Ú­ì¥»´N¬O³o¼Ë¡A¦ý§Ú­n¥[¤Wround¡A¤£µM§ÚÁ`­p·|¿ù»~¡A¦ýÁÙ¬OÁÂÁ§A

TOP

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

TOP

¦^´_ 4# ANGELA

=MID(R32,FIND("¸ô",R32,6)-2,3)

½Ð°Ý§Ú­n³o­Ó¤½¦¡·j´M¤£¨ì¸ô·j´Mµó¡A¨º§Ú­n«ç»òÅܧr¡A¸Õ¤F¦n´XºØ¤èªk³£¤£¯à¥Î¡AÁÂÁ§A

TOP

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

TOP

¥»©«³Ì«á¥Ñ s10002096 ©ó 2011-9-6 17:22 ½s¿è

¦^´_ 6# ANGELA

°ª¶¯¿¤¤jªÀ¶m(OR¥«ORÂí)¤¤µØ¸ô8¤§12¸¹
­n¦p¦ó§â¶m¥«Âí§ï¦¨°Ï©O¡H
  
  ÁÙ¦³ISERROR³o­Ó¨ç¼Æ«ç»ò¨Ï¥Î§r¡A¤£ºÞ«ç»ò®M¶i¤½¦¡¸Ì³£µLªk¥¿±`¹Bºâ
¯u±o«Ü·P¿E§A¦^µª¤F§Ú³o»ò¦hªº°ÝÃD¡I¡I:$

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 : ¤£­n¤p¬Ý¦Û¤v¡A¦]¬°¤H¦³µL­­ªº¥i¯à¡C
ªð¦^¦Cªí ¤W¤@¥DÃD