excel中if函数中怎么用两次or和and组合 Excel中IF和OR函数的组合使用
Excel\u4e2dif\u51fd\u6570\u600e\u6837\u548cand\uff0cor\u51fd\u6570\u4e00\u8d77\u4f7f\u7528IF\u51fd\u6570OR\u51fd\u6570AND\u51fd\u6570\u642d\u914d\u5d4c\u5957\u4f7f\u7528\u65b9\u6cd5
\u4f60\u5982\u679c\u4f1a\u8fd93\u4e2a\u51fd\u6570\u7684\u72ec\u7acb\u4f7f\u7528\uff0c\u6216\u8005\u4f60\u7406\u89e3\u4e86\u8fd93\u4e2a\u51fd\u6570\u7684\u8bed\u6cd5\uff0c\u8054\u5408 \u8d77\u6765\u7528\u4e5f\u5f88\u7b80\u5355\u554a\u3002 IF\u6761\u4ef6\u5224\u65ad\u51fd\u6570 AND\u6761\u4ef6\u201c\u4e0e\u201d\u7684\u903b\u8f91\u51fd\u6570\uff0c\u7ffb\u8bd1\u6210\u201c\u5e76\u4e14\u201d\u7684\u610f\u601d\u3002 OR\u6761\u4ef6\u201c\u6216\u201d\u7684\u903b\u8f91\u51fd\u6570\uff0c\u7ffb\u8bd1\u6210\u201c\u6216\u8005\u201d\u7684\u610f\u601d\u3002\u4e3e\u4e2a\u4f8b\uff1a =IF(OR(AND(A1=1,B1=1),AND(A1=2,B2=2)),\u201c\u6210\u7acb\u201d\uff0c\u201c\u4e0d\u6210\u7acb\u201d\uff09\u610f\u601d\u5c31\u662f\uff1a\u5982\u679cA1\u548cB1\u540c\u65f6\u4e3a1\uff0c\u6216\u8005\u540c\u65f6\u4e3a2\uff0c\u90fd\u8fd4\u56de\u6210\u7acb\uff0c\u5426\u5219\u8fd4\u56de\u4e0d\u6210\u7acb\u3002
公式如下：=if(and(B="及格",or(A="语文",A="数学"),"合格",if(and(B="不及格",or(A="语文",A="数学"),"补考",B))
=if(or(a1="语文",a1="数学"),if(b1="及格","合格",if(b1="不及格","补考",b1)),b1)
C1
=IF(AND(OR(A1="语文",A1="数学"),B1="及格"),"合格",IF(AND(OR(A1="语文",A1="数学"),B1="不及格"),"补考",D1)
绛旓細1銆侀鍏堟墦寮excel琛ㄦ牸锛岃緭鍏ュ鐢熷鍚嶅拰鎴愮哗锛岃缃瓑绾у垪銆2銆佹帴鐫鍦ㄧ瓑绾у垪涓紝杈撳叆鏉′欢璇彞=(IF(B2>=90,"浼樼",IF(B2>=80,"鑹ソ",IF(B2>=70,"涓瓑",IF(B2>=60,"鍙婃牸",IF(B2<60,"涓嶅強鏍")))锛屽洖杞﹀緱鍒扮瓑绾х粨鏋溿3銆佺劧鍚庡湪绗竴涓瓑绾у崟鍏冩牸鍙充笅瑙掍笅鎷夊～鍏呭叕寮忋4銆佸～鍏呭畬鎴愬悗锛屽涓嬪浘...
绛旓細Excel涓璉F鍑芥暟濡備綍鍚屾椂璁剧疆涓や釜婊¤冻鐨勬潯浠讹紝鍗虫弧瓒充换鎰忎竴涓嵆涓篢ure锛 鐢ㄦ硶锛氭妸涓嬮潰浠ｇ爜鏀捐繘vba妯″潡涓紝鐒跺悗鍦ㄦ煇涓崟鍏冩牸閲岄潰杈撳叆鍏紡=test(A,B,N) 銆怉锛孊锛孨鍙互鏄寚瀹氱殑鍊兼垨鑰呮煇涓崟鍏冩牸銆 function test(A,B,N as long) dim i,j for i = 1 to 65536 if range("M" & i)....
绛旓細1銆佺數鑴戞墦寮Excel琛ㄦ牸锛岃鍒ゅ畾J1澶т簬0锛孠1澶т簬0锛屽氨鏄剧ず1锛汮1澶т簬0锛孠1灏忎簬0锛屽氨鏄剧ず-1銆2銆佽緭鍏ュ叕寮=IF(AND(J1>0,K1>0),1,IF(AND(J1>0,K1<0),-1))銆3銆佽緭鍏ュ叕寮忓悗锛屾寜鍥炶溅閿嵆鍙垽鏂嚭J1澶т簬0锛孠1澶т簬0锛屽氨鏄剧ず1銆4銆佷笅鎷夊鍒跺叕寮廕1澶т簬0锛孠1灏忎簬0锛屽氨鏄剧ず-1銆
绛旓細excelif鍑芥暟澶氫釜鏉′欢鎬庝箞鐢锛烮F鍑芥暟鍦‥XCEL涓鏄竴涓熀纭鍑芥暟锛屽鐢ㄤ簬鏉′欢鍒ゆ柇锛岀劧鍚庢牴鎹潯浠跺垽鏂殑缁撴灉杩斿洖瀵瑰簲鐨勫唴瀹广IF鍑芥暟鐨浣跨敤闈炲父骞挎硾锛岀壒鍒槸鍦ㄥ崟鏉′欢鍒ゆ柇鐨勬椂鍊欙紝鐢ㄥソIF鍑芥暟鍙互甯垜浠畬鎴愬緢澶氬姛鑳姐侷F鍑芥暟鐢ㄦ硶锛氬垽鏂竴涓潯浠舵槸鍚︽弧瓒筹細濡傛灉婊¤冻杩斿洖涓涓硷紝濡傛灉涓嶆弧瓒冲垯杩斿洖鍙﹀涓涓笺侷F鍑芥暟璇硶...
绛旓細濂斤紝鍚﹀垯杩斿洖 鍧忋2.=IF(OR(A1=B1,A1>C1),"濂","鍧")OR鍒欐槸鎸囨弧瓒虫潯浠1鎴栬呮潯浠2锛屽彧瑕佹弧瓒充袱涓潯浠朵腑鐨勪竴涓紝鍒欒繑鍥 濂斤紝鍚﹀垯杩斿洖 鍧忋3.=if(鏉′欢1,if(鏉′欢2,"xxx","yyy"),"zzz")2.鍏紡鍐欐硶锛=if(鍒ゆ柇瀵归敊锛屽鏃舵樉绀虹粨鏋滐紝閿欐椂鏄剧ず缁撴灉锛夛紝濡:=if(a1>1,1,0);3.鍚庝袱涓...
绛旓細宸ュ叿锛歄ffice2007 鏂规硶濡備笅锛氬涓嬫暟鎹紝濡傛灉A鍒楃瓑浜庘滈奔鈥濇垨鑰匓鍒楃瓑浜1锛屽垯杩斿洖鈥滅湡鈥濓紝鍚﹀垯涓衡滃亣鈥濓細杈撳叆鍏紡濡備笅锛氫笅鎷夊～鍏呭緱鍒扮粨鏋滐細
绛旓細excel濡備綍閫氳繃鍏紡鏉ヨ缃潯浠舵牸寮忎互鍚屾椂婊¤冻涓や釜鏉′欢?婊¤冻澶氫釜鏉′欢涔熷彲浠ュ垎涓ょ鎯呭喌锛氬悓鏃舵弧瓒冲涓潯浠讹紱婊¤冻澶氫釜鏉′欢涓殑涓涓垨鑻ュ共涓嵆鍙傛垜浠互涓嬪浘鐨勬暟鎹潵涓句緥璇存槑銆傞鍏堬紝鍒╃敤AND()鍑芥暟鏉ヨ鏄庡悓鏃舵弧瓒冲涓潯浠躲備慨鏀筍MALL鍑芥暟鐨鏉′欢涓5+COUNTIF寰楀埌鐨勫硷紝涔熷氨鏄珮浜樉绀5+3=鍊掓暟8鍚嶅叏閮ㄩ珮浜樉绀猴紝鍚屾牱...
绛旓細excel涓璱f鍑芥暟鐢澶氫釜鏉′欢鐨勬柟娉曞涓嬶細宸ュ叿/鍘熸枡锛氳仈鎯冲皬鏂帮紝windows7锛宔xcel1.2.1銆1銆佸湪excel琛ㄦ牸涓殑A鍒楀崟鍏冩牸鍐呰緭鍏ヤ竴缁勬暟鎹紝鐢ㄦ潵浣跨敤IF鍑芥暟杈撳叆浜斾釜鏉′欢杩涜鏁版嵁鎿嶄綔銆2銆佸湪B2鍗曞厓鏍煎唴杈撳叆IF鍏紡锛=IF(A2<60,"1",IF(A2<100,"2",IF(A2<200,"3",IF(A2<280,"4",IF(A2<350,"5")))...
绛旓細鍦ㄥ伐浣滀腑锛 IF鍑芥暟鐢ㄧ殑姣旇緝澶氾紝鐪嬭捣鏉ュ緢绠鍗曠殑鍑芥暟锛屽鏋滃湪纰板埌澶氭潯浠剁殑鏃跺欙紝寰堝浜哄氨缁忓父鐘敊浜 涓銆佸熀鏈敤娉 IF(鍒ゆ柇锛屽锛岄敊)涓変釜鍙傛暟锛岀涓涓弬鏁版槸涓涓垽鏂叕寮忥紝绗簩涓弬鏁版槸姝ｇ‘鐨勬椂鍊欐樉绀虹殑缁撴灉锛岀涓変釜鍙傛暟鏄敊璇殑鏃跺欐樉绀虹殑缁撴灉 浜屻佸鏉′欢鐢ㄦ硶 鎴戜滑鏉ヤ妇渚嬭鏄庯紝濡備笅鎵绀猴紝鏄憳宸ョ哗鏁...
绛旓細鍙敤IF涔熸湁寰堝鎬绘柟娉曪紝涓嬮潰涓哄叾涓竴绉嶃侲3 =IF(C3="鐢","鐖",IF(C3="濂","姣","鏈煡"))&IF(C3="鏈煡","",IF(D3="鐢","瀛",IF(D3="濂","濂","鏈煡")))涓嬫媺澶嶅埗銆備篃鍙互閫氳繃鍒ゆ柇C3&D3=鈥滅敺鐢封濇垨鑰 鈥滅敺濂斥濊繖鏍疯繘琛屽垽鏂
