Excel的IF、AND、OR函数怎么组合使用?
绛旓細瀹炰緥1锛</鍦ㄦ垚缁╄〃涓紝鎴戜滑甯屾湜蹇熷垽鏂暟瀛︽垚缁╂槸鍚﹀悎鏍笺傚彧闇鐐瑰嚮H2鍗曞厓鏍硷紝杈撳叆鍏紡锛=IF(C2>=65, "鍚堟牸", "涓嶅悎鏍")銆傚彧闇婊¤冻鏉′欢锛岀粨鏋滃氨浼氳嚜鍔ㄦ樉绀恒傚鏋滅洰鏍囨槸鏍囪鎵鏈変笉鍙婃牸鐨勬垚缁╋紝鍙互浣跨敤绠娲佺殑浜屽厓琛ㄨ揪锛=IF(C2>=65, "", "涓嶅悎鏍")锛岀┖鐧借〃绀轰笉鍙婃牸銆備簩銆AND鍜OR鐨勮仈鍚堝姏閲</ ...
绛旓細1. IF鍑芥暟鐨勯瓟娉 IF鍑芥暟鏄Excel涓殑鍩虹鏉′欢鍒ゆ柇宸ュ叿锛屽叾璇硶绮剧偧锛欼F(鏉′欢琛ㄨ揪寮, 绗﹀悎鏉′欢杩斿洖鍊, 涓嶇鍚堟潯浠惰繑鍥炲)銆備緥濡傦紝瑕佹鏌2鍗曞厓鏍肩殑鏁板鎴愮哗鏄惁鍙婃牸锛屽彧闇鍦–2涓緭鍏ワ細=IF(B2>=60, "鍙婃牸", "涓嶅強鏍")濡傛灉鎴愮哗澶т簬绛変簬60锛屾樉绀"鍙婃牸"锛屽惁鍒欐樉绀"涓嶅強鏍"銆傞氳繃鍙屽嚮鍗曞厓鏍煎彸涓嬭锛屽嵆...
绛旓細1.If鍑芥暟宓屽AND鍑芥暟 =IF(AND(B2>=90,C2>=90),"浼樼","")锛涜〃绀哄鏋淏2澶т簬绛変簬90骞朵笖C2浜庣瓑浜90锛屽垯鏄剧ず浼樼,鍚﹀垯鏄剧ず涓虹┖銆1.If鍑芥暟宓屽OR鍑芥暟 =IF(OR(B2=100,C2=100),"婊″垎","")锛涜〃绀築2鍜孋2鍙鍙堜竴涓弧瓒崇瓑浜100锛屽氨鏄剧ず鈥滄弧鍒嗏濓紝鍚﹀垯鏄剧ず涓虹┖銆傚綋鏈夊涓潯浠堕渶瑕佸垽鏂椂锛岄渶瑕佺敤鍒...
绛旓細鍙涓氱哗澶т簬鎴栫瓑浜167涓囨椂锛屾瘡澶氫簬16.7锛岃瘎鍒嗗氨鍔10锛岀畻寮忎负锛氾紙涓氱哗-185锛夐櫎浠16.7锛屽啀涔樹互10.琛ㄨ揪寮忔槸锛=IF(A3>=167,((A3-185)/16.7)*10)銆傚洜涓鸿繕鏈夊彟涓鏉′欢锛屼笟缁╁皬浜167涓囨椂锛岃瘎鍒嗗噺20銆傜畻寮忓啓娉曚笌涓婃硶鐩稿悓銆備袱鏉′欢鍚屾椂鍒ゆ柇锛岀敤IF鍑芥暟杩涜宓屽銆傝〃杈惧紡濡備笅锛=IF(A3>=167,((A3-185)/...
绛旓細Excel鐨処F銆AND銆OR鍑芥暟缁勫悎浣跨敤鏂规硶锛氶鍏堜粙缁嶆渚嬭姹傦紝鏌愬叕鍙歌瀹氬涓嬨傦紙1锛夊伐璧勭骇鍒ぇ浜11绾т笖澶勪簬鍦ㄨ亴鐘舵侊紝楂樻俯琛ュ姪涓375鍏冦傦紙2锛夊伐璧勭骇鍒ぇ浜11绾т笖澶勪簬浼戝亣鐘舵侊紝楂樻俯琛ュ姪涓225鍏冦傦紙3锛夊彂宸ヨ祫鏈堜唤涓6鏈堛7鏈堛8鏈堛9鏈堣繖4涓湀鎵嶆湁楂樻俯琛ュ姪銆傞氳繃浠ヤ笂瑙勫畾鍙互鐭ラ亾锛屽彧鏈夊伐璧勭骇鍒ぇ浜11绾т笖鍙...
绛旓細Excel涓皢IF鍑芥暟鍜and銆or鍑芥暟涓璧蜂娇鐢ㄧ殑鎿嶄綔姝ラ 棣栧厛鎴戜滑鏉ョ湅涓涓嬫瘡涓嚱鏁扮殑鐢ㄦ硶锛氭湁澶氫釜鏉′欢骞剁珛鏃惰鐢AND鍑芥暟锛屼娇鐢ㄦ牸寮忥細AND(logical1,logical2, 鈥)澶氫釜鏉′欢鍙涓涓潯浠剁鍚堝氨鎴愮珛鐢OR鍑芥暟锛屼娇鐢ㄦ牸寮忥細OR(logical1,logical2,鈥)鏉′欢鎴愮珛鏃惰繑鍥炰竴涓,涓嶆垚绔嬫椂杩斿洖鍙︿竴涓兼椂鍙互鐢↖F鍑芥暟銆浣跨敤...
绛旓細鍏紡浣跨敤锛IF(AND(B4>=90,C4>=90),"浼樼锛傦紝IF(OR(B4>=90,C4>=90),"鑹ソ锛傦紝锛備竴鑸紓锛夛級銆傞紶鏍囨斁缃瓺4鍗曞厓鏍煎彸涓嬭锛屽彉涓洪粦鑹插崄瀛楋紝鍙屽嚮寰涓嬭嚜鍔ㄥ~鍏呭叕寮忥紝缁撴灉濡備笅锛氳鏄 鍦Excel2003涓嚱鏁癐F鍙互宓屽涓冨眰锛屽湪Excel2007涓彲浠ュ祵濂64灞傦紝鐢╲alue_if_false鍙妚alue_if_true鍙傛暟鍙互鏋勯犲鏉傜殑...
绛旓細if鍜宎nd鍜or鐨勪笁鑰呮贩鍚堝祵濂楀涓嬶細杩欐槸EXCEL鐨鏉′欢鍑芥暟浣跨敤鏂规硶銆傛墍璋鐨刬f鍜宎nd鍜宱r鐨勪笁鑰呮贩鍚堝祵濂楁寚鐨勬槸锛氬湪鍑芥暟鐨勭紪鍐欒繃绋嬩腑锛岄氳繃璁惧畾涓嶅悓鐨勬潯浠讹紝宓屽if鍜宎nd鍜宱r涓夌鏉′欢锛岃揪鍒版晥鏋溿傛瘮濡侷F+AND+OR涓夊嚱鏁拌仈鍚堜娇鐢ㄣ傛牴鎹敞閲婃潵鍒ゆ柇鍛樺伐鏄惁鍙互鏅嬪崌锛岃緭鍏ュ嚱鏁帮細=IF(OR(AND(C2="鐢",D2>3),AND(...
绛旓細1銆侀鍏堢偣鍑籩xcl杞欢銆2銆佺劧鍚庝細杩涘叆excl杞欢鐨勭晫闈3銆佺劧鍚庤緭鍏ヤ俊鎭4銆佺劧鍚庡湪鈥滃娉ㄢ濇爮涓緭鍏=if锛坆3>9,"涓嶈璐"锛屸滆璐р濓級銆5銆佺劧鍚庝笅鎷夎彍鍗曪紝鍏ㄩ儴鐨勯」鐩兘浼氭樉绀猴紝杩欏氨鏄痠f鍑芥暟鐨勪娇鐢ㄣ6銆佺劧鍚庡湪澶囨敞鏍忎腑杈撳叆=if锛坆3>9,"涓嶈璐"锛屸渋f锛坆3<6,"绱фヨ璐"锛屸滆璐р濓級锛夈7銆...
绛旓細Excel涓璉F銆OR銆AND閮芥槸閫昏緫鍑芥暟锛屽垎鍒涓:IF鍑芥暟鐢ㄤ簬鍒ゆ柇鍚庤繑鍥炲:绗竴涓弬鏁:鏉′欢寮忥紝蹇呴夊弬鏁;绗簩涓弬鏁:鏉′欢鎴愮珛鎵杩斿洖鐨勭粨鏋滐紝鍙夊弬鏁;绗笁涓弬鏁:鏉′欢涓嶆垚绔嬫墍杩斿洖鐨勫硷紝鍙夊弬鏁般侽R鈥滄垨鈥濆嚱鏁扮敱澶氫釜鍙傛暟缁勬垚锛岀瓑鍚屼簬IF鍑芥暟鐨勭涓涓弬鏁般傚涓弬鏁颁腑鏈変换鎰忎竴涓弬鏁版弧瓒虫潯浠讹紝鍏剁粨鏋滈兘鏄...