Excel2003中，如A1为85，A2为75，则在B1填A(大于或等于80打"A"),在B2填B(小于80大于或等于70打“B” 请教在Excel2003中若在A1输入90分时B1显示优秀，...
excel\u4e2dIF\u51fd\u6570\u5927\u4e8e\u7b49\u4e8e80\u4e14\u5c0f\u4e8e90\u5982\u4f55\u8868\u793a\u5728\u6307\u5b9a\u5355\u5143\u683c\u5185\u63d2\u5165\u51fd\u6570\u5982\u4e0b\uff1a=IF(AND(A1>=80,A1<90),"\u533a\u95f4\u5185","Wrong")
\u5176\u4e2d\uff0c\u82e5\u6ee1\u8db3\u6761\u4ef6\uff0c\u5219a2\u663e\u793a\u201c\u6ee1\u8db3\u6761\u4ef6\u201d\uff0c\u5426\u5219\u663e\u793a\u201cWrong\u201d,\u5177\u4f53\u64cd\u4f5c\u5982\u4e0b\uff1a
1\uff09A\u5217\u968f\u65f6\u8f93\u5165\u4e00\u4e9b\u6570\u503c\uff0cB\u5217\u83b7\u5f97\u6761\u4ef6\u540e\u7ed3\u679c\u3002
2\uff09\u5728B2\u5217\u8f93\u5165IF\u6761\u4ef6\u7684\u516c\u53f8\u201c=IF(AND(A1>=80,A1<90),"\u533a\u95f4\u5185","Wrong")\u201d\uff0c\u8bbe\u5b9a\u7ed3\u679c\u4e3a\uff1a\u6ee1\u8db3\u6761\u4ef6\uff0c\u8f93\u51fa\u201c\u533a\u95f4\u5185\u201d\uff0c\u4e0d\u6ee1\u8db3\u6761\u4ef6\uff0c\u8f93\u51fa\u201cWrong\u201d
3)B2\u5355\u5143\u683c\u8f93\u5b8c\u516c\u53f8\u540e\u56de\u8f66\uff0c\u83b7\u7684IF\u51fd\u6570\u7684\u503c\u4e3a\u201cWrong\u201d,\u67e5\u770b\u5de6\u8fb9\u6570\u636e\uff0c\u7b26\u5408IF\u6761\u4ef6\u903b\u8f91\uff0c\u6b64\u65f6\u9009\u4e2dB2\u5355\u5143\u683c\uff0c\u9f20\u6807\u79fb\u5230\u53f3\u4e0b\u89d2\u3002
4\uff09 \u9f20\u6807\u5904\u4e8e\u53ef\u7f16\u8f91\u72b6\u6001\uff0c\u5f80\u4e0b\u62d6\u52a8\u9f20\u6807\uff0c\u5c06IF\u51fd\u6570\u5e94\u7528\u5230\u9f20\u6807\u62d6\u52a8\u5230\u7684\u5217\u4f4d\u7f6e\uff0c\u5f39\u51fa\u5bf9\u5e94\u8bbe\u5b9a\u7ed3\u679c\u3002
\u697c\u4e3b,\u4f60\u662f\u4e0d\u6b62\u5728A1\u5230A3\u4e2d\u5b9e\u73b0\u8fd9\u4e2a\u6548\u679c\u5427.\u5982\u679c\u4f60\u662f\u53ea\u60f3\u5b9e\u73b0A1\u5230A3\u5355\u5143\u683c\u7684\u6548\u679c,\u90a3\u4f60\u5c31\u6309zjb22 - \u521d\u5165\u6c5f\u6e56 \u4e09\u7ea7 \u7684\u5c31\u53ef\u4ee5\u5b9e\u73b0.\u5982\u679c\u4e0d\u662f,\u90a3\u5c31\u770b\u4e00\u4e0b\u6211\u7684.
\u73b0\u5728\u6211\u4eec\u5047\u8bbe\u4f60\u7684\u6210\u7ee9\u8f93\u5728A1\u5230A100\u5217,\u4f18\u79c0,\u4e2d\u7b49,\u53ca\u683c\u7b49\u653e\u5728B\u5217,\u4f60\u73b0\u5728\u8f93\u5165\u4ee5\u4e0b\u516c\u5f0f\u5230B1,\u7136\u540e\u628a\u9f20\u6807\u653e\u5728B1\u5355\u5143\u683c\u7684\u53f3\u4e0b\u89d2,\u5f53\u9f20\u6807\u53d8\u6210\u4e00\u4e2a\u9ed1\u8272\u7684\u5341\u5b57\u67b6\u65f6,\u4e00\u76f4\u5f80\u4e0b\u62d6,\u62d6\u5230B100,\u8fd9\u6837,\u5f53\u4f60\u5728A\u5217\u8f93\u5165\u6210\u7ee9\u65f6,B\u5217\u4f1a\u6839\u636e\u4f60\u8f93\u5165\u7684\u6210\u7ee9\u663e\u793a\u4e0d\u540c\u7684\u7b49\u7ea7.\u5047\u8bbe\u4f60\u5728A2\u4e2d\u8f93\u5165100,B2\u4e2d\u5c31\u4f1a\u663e\u793a\u4f18\u79c0.\u5982\u679c\u4f60\u8f93\u516560,\u5b83\u5c31\u4f1a\u663e\u793a\u53ca\u683c.\u5176\u5b9e,\u6211\u4e5f\u662f\u7b2c\u4e00\u6b21\u505a\u516c\u5f0f,\u8bd5\u4e86N\u6b21\u624d\u8bd5\u51fa\u6765\u7684,\u4f46\u6211\u4e0d\u77e5\u9053\u4f60\u8981\u7684\u662f\u4e0d\u662f\u8fd9\u6837\u7684\u6548\u679c.=IF(A1>89,"\u4f18\u79c0",IF(A1>79,"\u4e2d\u7b49",IF(A1>59,"\u53ca\u683c","")))
\u5982\u679c\u662f\u5c0f\u4e8e60\u7684,\u5b83\u5c31\u4f1a\u663e\u793a\u7a7a\u767d\u7684\u5355\u5143\u683c
=if(A1>=80,"A",if(A1>=70,"B"))确认后B1会显示A，向下拖动B2中会显示B。
绛旓細COUNT锛A1,D1锛= 2 COUNT鍑芥暟鐨勪綔鐢ㄥ氨鏄繑鍥炲寘鍚暟瀛椾互鍙婂寘鍚弬鏁板垪琛ㄤ腑鐨勬暟瀛楃殑鍗曞厓鏍肩殑涓暟.
绛旓細闂涓锛Excel2003涓鎬庝箞绠楅櫎娉 寰堝鏄,渚嬪A1銆丅1涓垎鍒湁鏁版嵁锛欳1(浣犺鍐欑粨鏋滅殑鐣呮柟)涓彲浠ョ紪杈戝叕寮忎负 =A1/B1 鎴栬 =PRODUCT(A1锛1/B1)鍥炶溅纭銆傚彟澶栧叧浜庨櫎娉曪紝鍑芥暟涓湁涓涓槸姹備袱鏁扮浉闄ょ殑浣欐暟銆佷竴涓槸姹備袱鏁扮浉闄ゅ晢鐨勬暣鏁般傚彲浠ュ畨瑁匛XCEL缁勪欢鐒跺悗鍙傞槄鍑芥暟甯姪 闂浜岋細EXCEL琛ㄦ牸涓湁鍗曚綅锛屽浣...
绛旓細i) = List2.List(j) Then Exit For Next j If j = List2.ListCount Then List3.AddItem List1.List(i) End If Next i End Sub 姹excel2003涓紝濡傛灉A1鏈夊唴瀹癸紝A2鏃犲唴瀹广傞偅涔圓3锛1銆傚鏋淎1鏈夊唴瀹癸紝A2杩樻湁鍐呭锛屽垯A3=2銆 鍦ˋ3杈撳叆=if锛圓1<>"",if(A2="",1,2),"")
绛旓細If Range("a1")=1 Then Application.Run "aa"Else End If
绛旓細缁撴灉鏄104 鐩稿綋浜嶴UM(A1:D2)+SUM(B2:E3)
绛旓細宸ュ叿锛氭搷浣滅増鏈负EXCEL2003锛涘叕寮忥細锛滻F(A1<>0,NOW(),"")蹇嵎閿細F9 鎿嶄綔姝ラ锛1锛涜缃瓸1鍗曞厓鏍间负鏃ユ湡鍔犳椂闂磋繖绉嶆牸寮忥紱鍏夋爣鐐逛笅B1鍗曞厓鏍奸紶鏍囧彸鍑伙紝寮瑰嚭鐨勮彍鍗曚腑鐐光濊缃崟鍏冩牸鏍煎紡鈥滐紱2锛涘脊鍑虹殑鎿嶄綔妗嗕腑鐐光濇棩鏈熲滐紱鍦ㄥ彸杈硅繖閲岀偣閫夋椂闂存牸寮忥紝鏃ユ湡鍔犳椂闂磋繖绉嶆牸寮锛屽涓嬪浘鎵绀恒傚啀鐐圭‘瀹氥4锛涚偣纭畾...
绛旓細缁撴灉涓2 count 鍑芥暟鏍煎紡涓 count(v1,v2,v3...)锛屽叾涓紝V1,V2锛屽垎鍒〃绀轰竴缁勬暟鎹紝count鍑芥暟姹傝繖浜涙暟鎹腑鏁板奸」鐨勪釜鏁般
绛旓細浣犺鐨勫硷紝鍙互鏀惧彸杈笽鍒楋紝鐒跺悗鐢ㄥ叕寮忔煡鎵撅紝鏌ヤ笉鍒版椂灏辨樉绀0锛屾煡鍒板氨鏄剧ずC1.鍙互鐢=IF(ISERROR(VLOOKUP(A1,I:I,1,0)),0,C1)
绛旓細鏄姹A1:A200鎵鏈夊崟鍏冩牸鐨勫奸兘涓1鎵嶄慨鏀硅繕鏄姣忎釜鍗曞厓鏍硷紵杩欐槸寰幆鍒ゆ柇姣忎釜鍗曞厓鏍肩殑浠ｇ爜 Sub ChangeValue() Dim iRow As Integer Dim sValue As String For iRow = 1 To 200 sValue = Cells(iRow, 1).Value If sValue = "1" Then Cells(iRow, 1).Value = Cells(201...
绛旓細锛堜竴锛夊綋涓涓崟鍏冩牸鏄湡绌烘垨鍋囩┖鏃讹紝閮藉彲浠ョ敤 "" 鏉ヨ〃绀 濡傝鍒ゆ柇A1鍗曞厓鏍兼槸鍚︿负绌哄崟鍏冩牸锛屽垯鍙叆鍏紡 =IF(A1="","鐪熺┖鎴栧亣绌","鏈夊唴瀹")锛堜簩锛夊湪鐪熺┖鎴栧亣绌哄崟鍏冩牸涓紝鐢↙EN缁熻瀛楃涓暟鏃跺緱鍑虹殑鍊煎簲涓0涓 =LEN(A1) 銆傛敞鎰忥細="" 鏄亣绌猴紱=" " 涓嶆槸鍋囩┖锛岃櫧鐒跺悓鏍风湅涓...
