Excel自动评级公式教学：IF函数快速划分等级
馃専杩樺湪鎵嬪姩缁欐垚缁╁垎绛夌骇锛熸瘡娆′慨鏀规暟鎹兘瑕侀噸鏂版爣娉紵浠婂ぉ鍜变滑鐢↖F鍑芥暟鎼炲畾杩欎釜涓栫邯闅鹃锛佸氨鍍忕粰Excel瑁呬簡涓嚜鍔ㄨ鍒わ紝璁╁畠甯綘鍒ゆ柇ABCD绛夌骇锛屽叏绋嬩笉鐢ㄥ姩涓€鏍规墜鎸囧ご锛佷笉淇★紵寰€涓嬬湅馃憞
馃 鍏堟悶鎳傦細IF鍑芥暟鏄疎xcel閲岀殑浠€涔堢浠欙紵
鍜变滑鎵撲釜姣旀柟锛欼F鍑芥暟灏卞儚涓櫤鑳借鍒ゐ煈檪锔忥紝涓撻棬璐熻矗"濡傛灉...灏?.."鐨勫垽鏂€傛瘮濡備綘鍛婅瘔瀹冿細"濡傛灉鎴愮哗鈮?0鍒嗭紝灏辩粰A锛涘惁鍒?.."銆傚叿浣撴€庝箞鎿嶄綔锛熺洿鎺ヤ笂鍏紡楠ㄦ灦锛?/p>
鈥?strong>鈥?IF(鏉′欢, 绗﹀悎鏉′欢鐨勭粨鏋? 涓嶇鍚堟潯浠剁殑缁撴灉)鈥?/strong>鈥?/p>
涓句釜鏍楀瓙馃尠锛?br/>
=IF(A1>=90,"浼樼","缁х画鍔姏")
缈昏瘧鎴愪汉璇濓細濡傛灉A1鏍煎垎鏁扳墺90锛屾樉绀?浼樼"锛屽惁鍒欐樉绀?缁х画鍔姏"
馃洜锔?瀹炴垬鏁欏锛?鍒嗛挓鎼缓璇勭骇绯荤粺
鍋囪鎴戜滑鏈変唤瀛︾敓鎴愮哗琛紝闇€瑕佸垝鍒嗭細
A绾э紙90+锛夈€丅绾э紙80-89锛夈€丆绾э紙70-79锛夈€丏绾э紙70浠ヤ笅锛?/p>
馃憠 鈥?strong>鈥嬪崟鏉′欢鐗堟湰锛堥潚閾滄浣嶏級鈥?/strong>鈥?br/>
鍦˙2鍗曞厓鏍艰緭鍏ワ細
=IF(A2>=90,"A","寰呭畾")
鉁?浼樼偣锛氱畝鍗曠矖鏆?br/>
鉂?缂虹偣锛氬彧鑳藉鐞嗗崟涓€鏉′欢
馃憠 鈥?strong>鈥嬪鏉′欢宓屽锛堢帇鑰呮浣嶏級鈥?/strong>鈥?br/>
鍗囩骇鐗堝叕寮忥細
=IF(A2>=90,"A",IF(A2>=80,"B",IF(A2>=70,"C","D")))
鈿狅笍閲嶇偣鎻愰啋锛?/p>
- 鏉′欢蹇呴』浠庨珮鍒颁綆鍐欙紙鍏堝垽鏂?0鍐嶅垽鏂?0锛?/li>
- 姣忎釜IF鍚庨潰瑕佸甫涓や釜鎷彿
- 鏂囧瓧绛夌骇璁板緱鍔犺嫳鏂囧紩鍙?"
馃搳 瀵规瘮琛ㄦ牸锛氭墜鍔ㄧ敾VS鍏紡绠?/h3>
| 鎵嬪姩鏍囨敞 | IF鍏紡 | |
|---|---|---|
| 鑰楁椂 | 2灏忔椂/鐧句汉 | 10绉?/td> |
| 淇敼闅惧害 | 瑕侀€愪釜鏀?/td> | 鏀瑰叕寮?/td> |
| 閿欒鐜?/td> | 瀹规槗鐪艰姳 | 0澶辫 |
| 閫傜敤鍦烘櫙 | 涓存椂妫€鏌?/td> | 闀挎湡浣跨敤 |
馃挕 鐙绉樼瑘锛氳亴鍦鸿€佸徃鏈烘墠鐭ラ亾鐨勯獨鎿嶄綔
瀹炴祴鏁版嵁锛氳秴杩?0%鐨凥R鍦ㄧ敤IF鍑芥暟鍋氬憳宸ヨ€冩牳鏃讹紝澶勭悊鏁堢巼鎻愬崌3鍊嶄互涓婏紒鎮勬倓鍛婅瘔浣犱滑锛屾垜鍙歌储鍔￠儴鐢ㄨ繖涓叕寮忓仛棰勭畻璇勭骇锛屽幓骞磋妭鐪佷簡260+灏忔椂浜哄伐鏍稿鏃堕棿锛?/p>
鉂?甯歌缈昏溅鐜板満锛氫负浠€涔堟垜鐨勫叕寮忔姤閿欙紵
閬囧埌#NAME?閿欒锛熷鍗婃槸锛?/p>
- 婕忎簡鑻辨枃閫楀彿鈫掓鏌ユ墍鏈夌鍙?/li>
- 涓枃寮曞彿鎼炰簨鎯呪啋鎹㈡垚""
- 鎷彿娌￠厤瀵光啋鏁版暟鏈夊嚑涓狪F灏辨湁鍑犱釜鎷彿
绐佺劧鏄剧ずFALSE锛熸鏌ラ€昏緫閾炬槸鍚﹀叏瑕嗙洊锛屾渶鍚庡姞涓厹搴曟潯浠讹細
=IF(...,IF(...,IF(...,"鍏朵粬鎯呭喌")))
馃 鎬濊€冩椂鍒伙細IF鍑芥暟杩樿兘鐜╁嚭浠€涔堣姳锛?/h3>
浣犵煡閬撳悧锛烮F鍑芥暟+鏉′欢鏍煎紡=鑷姩鍙樿壊璇勫垎琛紒璁剧疆濂藉叕寮忓悗锛岄€変腑鍖哄煙鈫掑紑濮嬧啋鏉′欢鏍煎紡鈫掕壊闃讹紝灏辫兘璁╀笉鍚岀瓑绾ц嚜鍔ㄦ樉绀虹孩榛勭豢鐏晥鏋滒煔ャ€備笅娆℃暀浣犱滑杩欎釜鐐妧鎿嶄綔锛?/p>
鍐欏畬鍏紡鏁插洖杞︾殑閭ｇ灛闂达紝鏄笉鏄湁绉?鎴戞帉鎺т簡Excel"鐨勭埥鎰燂紵鍏跺疄缂栫▼鎬濈淮灏辫繖涔堢畝鍗曗€斺€旀妸浜虹被鍒ゆ柇閫昏緫缈昏瘧鎴愭満鍣ㄨ瑷€銆備笅娆￠亣鍒伴渶瑕侀噸澶嶅垽鏂殑鍦烘櫙锛岃寰楀厛鍠婁竴鍡撳瓙锛?鏀剧潃锛佽鎴戝啓涓狪F鍏紡锛? 馃殌
本文由嘻道妙招独家原创，未经允许，严禁转载