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

[µo°Ý] ¦h¼hIF¸Ó«ç»ò¼g©O?

[µo°Ý] ¦h¼hIF¸Ó«ç»ò¼g©O?

¦pªG
A1=A -> B1=B
A1=B -> B1=A
A1=C -> B1=C

³o¨Ç±ø¥ó­n«ç»ò¥Î¼g©O?

¦^´_ 1# v60i


    B1=IF(A1="A","B",IF(A1="B","A",IF(A1="C","C","")))

TOP

·PÁ¤j¤jÁÂÁÂ

TOP

¦^´_ 3# v60i


    B1=CHOOSE(CODE(A1)-64,"B","A","C")
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 4# Hsieh


    ½Ð°Ý¤j¤j-64 ¬O¤°»ò·N«ä©O?

TOP

¦^´_ 5# v60i
Aªº¦r¤¸½X¬O65
©Ò¥H´î64«á´N¬O1
«K¥i¥Ñ¦r¤¸½X¨Ó¿ï¾Ü«á­±¤Þ¼Æ
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¹ï©ó³oÃþ«¬ªº»Ý¨D¡AHsiehª©¤j³o©Û¯uªº¤£¿ù

TOP

¦^´_ 6# Hsieh


    ®@®@ ­ì¨Ó¬O¦r¤¸½X

¥i¬O¦p¬Oa ªº¸Ü ­n«ç»ò¦b²K¥[©O?
ASCII 097

«¢~¸Ñ¨M¤@­Ó°ÝÃD«á¤S©µ¦ù¤@­Ó°ÝÃD

TOP

¦^´_ 8# v60i


   ¤½¦¡ªº¹B¥Î­n¨Ì¾Ú¸ê®Æ³W«h¨Ó¼g
¤£¤@¼Ëªº¸ê®Æ³W«h´N·|¦³¤£¦P°µªk
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 10# ccwang58
³Ì²Âªº¤èªk
¿ï¨úAÄæ
¿é¤J¤½¦¡=CHAR(ROW())
«öCTRL+ENTER§¹¦¨¿é¤J
¦bAÄæ§ä¨ì§A­nªº¦r¤¸¡A©Ò¦b¦C¸¹´N¬O¦r¤¸½X
play.gif
2011-11-30 11:29
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ¹D¼w¬O´£ª@¦Û§Úªº©ú¿O¡A¤£¸Ó¬O¨þ¥¸§O¤HªºÃ@¤l¡C
ªð¦^¦Cªí ¤W¤@¥DÃD