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

[µo°Ý] ¦p¦óÃѧO¯S©w±ø¥óªº¼Æ­È¨Ã§ï¦rÅé¤j¤p©MÃC¦â?

[µo°Ý] ¦p¦óÃѧO¯S©w±ø¥óªº¼Æ­È¨Ã§ï¦rÅé¤j¤p©MÃC¦â?

test.png

¦p¦ó·í§Ú¦b¦P¤@Àx¦s®æ·í¤¤
¿é¤J­t¼Æ©Î¥¿¼Æ(±ø¥ó¬°¥²¶·¦³+/-¸¹)®É
¦Û°Ê§â
­t¼Æ§ï¦rÅé¤j¤p¬°10, ÃC¦â¬°¬õ¦â
¥¿¼Æ§ï¦rÅé¤j¤p¬°10, ÃC¦â¬°ºñ¦â

Many thanks!

½Ð°Ý¦³®v¥Sª¾¹D¦³¤½¦¡¥i¥H°µ¨ì¥H¤W®ÄªG¶Ü?

TOP

³]©w®æ¦¡¤Æ±ø¥ó¤º«Ø
±ø¥ó¤@¤½¦¡
=ISERROR(SEARCH("+",$A$1))=FALSE
±ø¥ó¤G¤½¦¡
=ISERROR(SEARCH("-",$A$2))=FALSE
µM«á³]»Ý¨DÃC¦â
ù

TOP

³]©w®æ¦¡¤Æ±ø¥ó¤º«Ø
±ø¥ó¤@¤½¦¡
=ISERROR(SEARCH("+",$A$1))=FALSE
±ø¥ó¤G¤½¦¡
=ISERROR(SEARCH("-",$A ...
rouber590324 µoªí©ó 2018-9-12 09:53



ÁÂÁ®v¥S¸Ñµª
³]©w¤F«á, ¥u¥X²{ªº¬O¦P¤@¥u¦â
°µ¤£¨ì¹Ï¤¤ªº®ÄªG...

TOP

«ö"·s¼W"¥i¥X²{±ø¥ó¤@»P±ø¥ó¤G ¨Ñ¤£¦P±ø¥ó¤£¦PÃC¦â³]©w
¤À§O³]©w
±ø¥ó¤@¤½¦¡
=ISERROR(SEARCH("+",$A$1))=FALSE - ¬õ¦â
±ø¥ó¤G¤½¦¡
=ISERROR(SEARCH("-",$A$2))=FALSE - ºñ¦â
§Y¥i
ù

TOP

«ö"·s¼W"¥i¥X²{±ø¥ó¤@»P±ø¥ó¤G ¨Ñ¤£¦P±ø¥ó¤£¦PÃC¦â³]©w
¤À§O³]©w
±ø¥ó¤@¤½¦¡
=ISERROR(SEARCH("+",$A$1 ...
rouber590324 µoªí©ó 2018-9-12 13:09



   

³o¼Ë¶Ü?
¦ý«ö¤F½T©w«á¨SÅܤÆ

TOP

google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

hcm19522 µoªí©ó 2018-9-12 13:54



    ÁÂÁ®v¥S¸Ñµª
¦ý¥Ñ©ó¤p§Ì¬OEXCEL·s¤â
¬G«Ü¦h³N»y³£¤£¤Ó©ú¥Õ

§ÚÀ³¸Ó¦b¨º¨à¿é¤J³o¦æ«ü¥O?
(¤@)B2:D9®æ¦¡¤Æ (¬õ¦â)=-B2>0

°²³]¬O¶Â¦â¦r, ¥¿¼Æ¬°ºñ¦â, ­t¼Æ¬°¬õ¦â, À³¸Ó«ç»ò¿ì
(¤G)¥þ¶ñº¡ºñ¦â

Sorry for so many stupid questions.:Q
Many thanks!

TOP

¦^´_ 8# yahoohk1314


    ®æ¦¡¤Æ :°é¿ï½d³ò-->奌¤W¤è "³]©w®æ¦¡¤Æªº±ø¥ó" -->·s¼W³W«h-->¨Ï¥Î¤½¦¡¨Ó¨M©w¨º¨ÇÀx¦s®æ-->¤U¤½¦¡-->¿ï¦â-->½T©w
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

­øª¾¦U¦ì¬O§_»~·|¤F¤Ö¤Ö
§Ú¬O¦P¤@­ÓÀx¦s®æ¤ºªº
¦Ó¤£¬O¨C¤@­Ó¼Æ­È¬°¤@®æ
¥H¤Wºâ¦¡¦n¹³³£¤£¯à¨Ï¥Î
§Ú¤Ó·MÄø¤F
°µ·¥³£¹F­ø¨ì§Ú·Q­nªº®ÄªG
¦³®v¥S¥i¥H°µ¤@¤UEXCELÀÉ¥X¨Óµ¹¤p§Ì¬ã¨s¶Ü
·P¿E¸U¤À:'(

¦P¤@Àx¦s®æ¤ºªº¼Æ­È¬°:
23.06 +0.34 22.14 -0.14 24.14 -0.99

TOP

        ÀR«ä¦Û¦b : ½_ÁJµ²±o¶V¹¡º¡¡A¶V·|©¹¤U««¡A¤@­Ó¤H¶V¦³¦¨´N¡A´N­n¶V¦³Á¾¨Rªº¯ÝÃÌ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD