在excel中如何用if函数说明大于等于90分为优秀,85至89分为良好,75至84分为一般?test EXCEL题IF函数：指定单元格G1，若大于90分为优秀，在...
Excel\u4e2d\u7684IF\u51fd\u6570\u600e\u4e48\u7528\uff1f\u4f8b\uff1aE1\u5230E32\u4e2d\uff0c\u5927\u4e8e90\u7684\u4e3a\u4f18\uff0c\u5c0f\u4e8e90\u7684\u4e3a\u826f\u5728F1\u8f93\u5165=IF(E1>=90,"\u4f18","\u826f"\uff09,\u7136\u540e\u7528\u9f20\u6807\u5f80\u4e0b\u4e00\u62d6\u5c31OK\u4e86\uff0c\u8fd9\u4e2a\u51fd\u6570\u5c31\u662f\u8bf4\u5f53E1\u7684\u6570\u503c\u5927\u4e8e\u7b49\u4e8e90\u65f6\uff0c\u663e\u793a\u4f18\uff0c\u5426\u5219\u663e\u793a\u826f\u3002
\u5982\u679c\u4f60\u9700\u8981\u66f4\u591a\u7684\u5224\u65ad\uff0c\u90a3\u4e48 \u628a\u4f18\u6216\u8005\u826f\u518d\u66ff\u6362\u4e3aif\u51fd\u6570\uff0c\u5f62\u6210\u5d4c\u5957\u51fd\u6570\u5c31OK\u4e86\u3002\u4f8b\u5982\u5927\u4e8e90\u7684\u4e3a\u4f18\uff0c\u5927\u4e8e\u7b49\u4e8e80\u5c0f\u4e8e90\u7684\u4e3a\u826f\uff0c\u5176\u4ed6\u4e3a\u4e00\u822c\uff0c\u90a3\u4e48\u5c31\u8f93\u5165=IF(E1>=90,"\u4f18",IF(E1<80,""\u4e00\u822c","\u826f")),
=IF(G1>=90,"\u4f18\u79c0",IF(AND(G1>=75,G1<90),"\u826f\u597d","\u4e2d"))
图片假设分数在A列中。在B1单元格输入=IF(AND(A1>=75,A1<=84),"一般",IF(A1<=89,"良好","优秀"))=IF(A1>=90,"优秀",IF(A1>=85,"良好","一般"))
假设分数在A列中。
在B1单元格输入
=IF(AND(A1>=75,A1<=84),"一般",IF(A1<=89,"良好","优秀"))
=IF(B2>=90,"优秀",IF(AND(B2<90,B2>=85),"良好",IF(AND(B2>=75,B2<85),"一般",IF(B2<60,"不及格"))))
希望能帮到你。
绛旓細Excel鏁版嵁鍒嗘瀽鎶宸э細濡備綍鐢↖F鍑芥暟杩涜鏁板煎垽鏂 Excel浣滀负涓娆惧己澶х殑鐢靛瓙琛ㄦ牸杞欢锛岃骞挎硾搴旂敤浜庡悇涓鍩熴傚叾涓紝鏁版嵁鍒嗘瀽鏄疎xcel鏈涓哄父瑙佺殑鐢ㄩ斾箣涓銆傚湪鏁版嵁鍒嗘瀽杩囩▼涓紝鎴戜滑缁忓父闇瑕佹牴鎹煇浜涙潯浠惰繘琛屾暟鍊煎垽鏂紝杩欐椂灏遍渶瑕佺敤鍒Excel涓鐨処F鍑芥暟銆侷F鍑芥暟鐨勫熀鏈娉曟槸锛欼F(鏉′欢,鎴愮珛鏃剁殑鍊,涓嶆垚绔嬫椂鐨勫)銆傚叾涓...
绛旓細IF 鍑芥暟璇硶鍏锋湁涓嬪垪鍙傛暟 logical_test 蹇呴渶銆 璁＄畻缁撴灉涓 TRUE 鎴 FALSE 鐨浠讳綍鍊兼垨琛ㄨ揪寮忋備緥濡傦紝A10=100 灏辨槸涓涓昏緫琛ㄨ揪寮忥紱濡傛灉鍗曞厓鏍 A10 涓殑鍊肩瓑浜 100锛屽垯琛ㄨ揪寮忕殑璁＄畻缁撴灉涓 TRUE銆 鍚﹀垯锛岃〃杈惧紡鐨勮绠楃粨鏋滀负 FALSE銆傛鍙傛暟鍙互浣跨敤浠讳綍姣旇緝璁＄畻杩愮畻绗︺倂alue_if_true 鍙夈 logical...
绛旓細瀵逛簬瀛︿範Excel鐨鍚屽鏉ヨ锛屼簡瑙Excel鍑芥暟鏈寮濮嬫帴瑙﹀埌鐨勫簲璇ュ氨鏄疘F鏉′欢鍒ゆ柇鍑芥暟銆傝繖涓嚱鏁板湪瀹為檯杩愮敤涓篃鏄潪甯哥殑鏅亶銆備綔涓轰竴绉嶉昏緫鍒ゆ柇鍑芥暟锛屽浜庤澶氬悓瀛︽潵璇达紝鎰熻涔熸槸闈炲父鐨勯毦銆備粖澶╂垜浠氨鏉ラ氳繃鍥涗釜妗堜緥锛屾潵鍔犳繁澶у瀵逛簬IF鍑芥暟鐨勭悊瑙ｃ備竴銆佸嚱鏁拌В鏋愶細IF鍑芥暟浣滀负涓绉嶉昏緫鍒ゆ柇鍑芥暟锛屽畠鐨勬渶缁堢粨鏋滄槸杩斿洖True...
绛旓細鏍规嵁IF鍑芥暟鐨鍙傛暟瀹氫箟锛岀涓鏉′欢涓哄垽鏂潯浠讹紝褰撶涓鍙傛暟鎴愮珛鐨勬椂鍊欙紝缁撴灉灏辨樉绀虹浜屽弬鏁扮殑鍊硷紱褰撶涓鍙傛暟鏉′欢涓嶆垚绔嬬殑鏃跺欙紝鎵ц绗笁鍙傛暟鐨勫笺備緥濡傚綋璐ㄦ鍒嗘暟灏忎簬80鍒嗭紝浜у搧妫娴嬩笉鍚堟牸锛屽弽涔嬪悎鏍硷紝鍏紡涓猴細=IF(D4<80,"涓嶅悎鏍","鍚堟牸")
绛旓細IF鏄疎xcel涓槸涓涓熀纭鍑芥暟锛屽鐢ㄤ簬鏉′欢鍒ゆ柇锛岀劧鍚庢牴鎹潯浠跺垽鏂殑缁撴灉杩斿洖瀵瑰簲鐨勫唴瀹广鍦‥xcel涓锛孖F鍑芥暟鍙互鏍规嵁涓涓潯浠舵潵杩斿洖涓嶅悓鐨勭粨鏋溿備絾鏄湁鏃跺欓渶瑕佹牴鎹涓潯浠舵潵鍒ゆ柇杩斿洖缁撴灉锛岃繖鏃跺欏氨闇瑕浣跨敤IF鍑芥暟鐨勫祵濂楄鍙ユ潵瀹炵幇銆傚祵濂桰F鍑芥暟鐨勮娉曞涓嬶細=IF锛堟潯浠1锛岀粨鏋1锛孖F锛堟潯浠2锛岀粨鏋2锛孖F锛堟潯浠3...
绛旓細娆㈣繋鏉ュ埌Excel鎶宸у鍫傦紒浠婂ぉ锛屾垜浠皢娣卞叆鎺㈣Excel涓笉鍙垨缂虹殑IF鍑芥暟锛屽畠濡備綍閫氳繃鏉′欢鍒ゆ柇璧嬩簣鏁版嵁椴滄椿鐨勯昏緫銆傝繖涓姛鑳藉浜庢彁鍗囨暟鎹鐞嗘晥鐜囪嚦鍏抽噸瑕併傜涓姝ワ紝璁╂垜浠簡瑙濡備綍浣跨敤瀹冦鍦‥xcel鐨璁＄畻涓栫晫閲岋紝IF鍑芥暟灏卞儚涓涓櫤鎱х殑瑁佸垽锛屽綋浣犺緭鍏ヤ竴涓潯浠讹紝瀹冧細鍒ゆ柇缁撴灉鏄滅湡鈥濓紙TRUE锛夎繕鏄滃亣鈥濓紙FALSE...
绛旓細if鍏紡鏄Excel涓闈炲父甯哥敤鐨鍑芥暟涔嬩竴锛屽畠鐨勪綔鐢ㄦ槸鏍规嵁涓涓潯浠舵潵鍒ゆ柇骞惰繑鍥炰笉鍚岀殑缁撴灉銆傝岃繖涓潯浠跺彲浠ユ槸鏁板瓧锛屼篃鍙互鏄枃鏈傛湰鏂囧皢閲嶇偣浠嬬粛if鍏紡鐨勬潯浠朵负鏂囨湰鏃剁殑鐢ㄦ硶銆傞鍏堬紝鎴戜滑闇瑕佷簡瑙f鍏紡鐨勫熀鏈娉曪細=IF(鏉′欢, 鐪熷, 鍋囧)锛屽叾涓潯浠跺彲浠ユ槸浠讳綍鑳藉杩斿洖TRUE鎴朏ALSE鐨勮〃杈惧紡锛岀湡鍊煎拰鍋囧煎垯鏄搴...
绛旓細excel涓璱f鍑芥暟鐨勭敤娉曪細 鎿嶄綔璁惧锛氳仈鎯砊hinkpad銆 鎿嶄綔绯荤粺锛歸in10涓撲笟鐗堛 鎿嶄綔杞欢锛欵xcel銆1銆侀鍏堣繘鍏xcel杞欢涓紝鎵惧埌鑷繁鍑嗗瑕佸鐞嗙殑琛ㄦ牸鏁版嵁锛屽叿浣撳鍥炬墍绀恒2銆佹壘鍒版暟鎹〃鏍煎悗锛屾寜鐓у浘涓澶村拰绾㈣壊妗嗘寚绀猴紝鑷繁鍙互鎸夌収鑷繁闇姹傞夋嫨涓涓┖鐧界殑鍗曞厓鏍硷紝鐒跺悗鍦鍑芥暟杈撳叆鏍忎腑杈撳叆鍑芥暟...
绛旓細绗竴涓┖鏍煎唴濉紝D3>=20%锛涚浜屼釜绌烘牸鍐呭～锛岃緝蹇紱绗笁涓┖鏍煎唴锛屼笉濉垨鑰呯┖鏍笺Excel涓璉F鍑芥暟鐨勮〃杈惧紡涓猴細IF(logical_test,value_if_true,value_if_false)锛孡ogical_test琛ㄧず璁＄畻缁撴灉涓篢RUE鎴朏ALSE鐨勪换鎰忓兼垨琛ㄨ揪寮忋俈alue_if_true琛ㄧず鐨勬槸 logical_test涓篢RUE鏃惰繑鍥炵殑鍊糣alue_if_false琛ㄧず鐨勬槸 ...
