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

½Ð°Ý¡I³o­ÓÀx¦s®æ°ÝÃD¸Ó¦p¦ó¸Ñ¨M©O¡IÁÂÁ¡I

½Ð°Ý¡I³o­ÓÀx¦s®æ°ÝÃD¸Ó¦p¦ó¸Ñ¨M©O¡IÁÂÁ¡I

°²³]¦ba1Àx¦s®æ¤W¥´¤W°ê¥ÁÄÒ¡Aa2Àx¦s®æ¤W¥´¤W¥Á¶iÄÒ
¦p¦ó¦bb1Àx¦s®æ´N¶]¥XÂŦâ³o¨â­Ó¦r¡Ab2Àx¦s®æ ´N¶]¥Xºñ¦â³o¨â­Ó¦r
½Ð°Ý¸Ó¦p¦ó³]©w©O¡HÁÂÁ¡I

¥»©«³Ì«á¥Ñ yanto913 ©ó 2011-4-6 01:17 ½s¿è

B1=IF(A1="°ê¥ÁÄÒ","ÂŦâ",IF(A1="¥Á¶iÄÒ","ºñ¦â",IF(A1="","","¨ä¥¦ÄÒ")))
YOYO

TOP

b1=IF(A1="","",IF(A1="°ê¥ÁÄÒ","ÂŦâ","ºñ¦â"))--¦V¤U«þ¨©

TOP

=VLOOKUP(A1,{"°ê¥ÁÄÒ","ÂŦâ";"¥Á¶iÄÒ","ºñ¦â";0,""},2,0)

TOP

¦U¦ì¤j¤j¡I¤p§Ì¤F¸Ñ¤F¡IÁÂÁ¡I

TOP

¬Ý¨ì¦nª±ªº
A1Àx¦s®æ="°ê¥ÁÄÒ"«oÅã¥Ü"ÂŦâ"

³]©wÀx¦s®æ®æ¦¡=¦Û­q
[="°ê¥ÁÄÒ"]"ÂŦâ";G/³q¥Î®æ¦¡

TOP

        ÀR«ä¦Û¦b : ¥Í®ð¡A´N¬O®³§O¤Hªº¹L¿ù¨ÓÃg»@¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD