excel多条件判断,并返回值。答:C2=IFERROR(VLOOKUP(A2&B2,IF({1,0},$F$2:$F$15&$G$2:$G$15,$H$2:$H$15),2,),"")或者=IFERROR(INDEX(H:H,MATCH(A2&B2,$F$1:$F$15&$G$1:$G$15,)),"")数组公式向下复制【数组公式,公式输完后,光标放在公式编辑栏同时按下CTRL+SHIFT+回车键,使数组公式生效】...
EXCEL多条件符合返回固定值答:D11=OFFSET($A$1,MATCH(C11,$A$2:$A$7,0),MATCH(B11,$B$1:$G$1,0))或者=INDEX($B$2:$G$7,MATCH(C11,$A$2:$A$7,0),MATCH(B11,$B$1:$G$1,0))或者=SUMPRODUCT(($B$1:$G$1=B11)*($A$2:$A$7=C11)*$B$2:$G$7)向下复制 ...
excel 多条件判断 返回某一值答:=IF(AND(85<=A2,A2<100),4,IF(AND(80<=A2,A2<85),3.5,IF(AND(75<=A2,A2<80),3,IF(AND(70<=A2,A2<75),2.8,IF(OR(A2>100,A2<70),"")))A2替换为L2