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

[µo°Ý] ¦bEXCEL ªº¤½¦¡¤¤¦p¦ó¶i¦æµù¸Ñ

[µo°Ý] ¦bEXCEL ªº¤½¦¡¤¤¦p¦ó¶i¦æµù¸Ñ

½Ð°Ý,¦bEXCELªº¤½¦¡¤¤¦p¦ó¥[¤Jµù¸Ñ
¨Ò¦p IF(A2="1","a","b")
§Ú­n¦b¤½¦¡¤¤ª½±µMEMO a=¤µ¤Ñ
¤£ª¾¹D¦U¦ì¤j¤j¥i¥H¤F¸Ñ§Úªº°ÝÃD¶Ü?
¤p¯QÀt

¥»©«³Ì«á¥Ñ ANGELA ©ó 2010-8-31 12:48 ½s¿è

¦^´_ 1# judy7352


    =IF(A2="1","a","b")&"  "&T("A=¤µ¤Ñ")
  §Ú·Q³o¤£¬O§A­nªºµª®×,¦pªG§Aªºµª®×¬O¼Æ­Èªº¸Ü¥i¥H¥Î
  =IF(A2=1,100,1000)+N("100=¤µ¤Ñ")

TOP

        ÀR«ä¦Û¦b : ¤Hªº¤ß¦a¬O¤@²¥¥Ð¡A¤g¦a¨S¦³¼½¤U¦nºØ¤l¡A¤]ªø¤£¥X¦nªºªG¹ê¡C -
ªð¦^¦Cªí ¤W¤@¥DÃD