EXCEL中用函数写出来如:当a=b时输出c,当a=d时输出e,当a=f时输出g,以...答:或者 =vlookup(a,{b,c;d,e;f,g},2,)或者 =LOOKUP(A1,{b,d,f;c,e,g})
excel 公式 按指定的优先等级筛选数据答:B","C","D","E"})>0)*1)=5,"A",IF(SUMPRODUCT((COUNTIF(D1:D100,{"B","C","D","E"})>0)*1)=4,"B",IF(SUMPRODUCT((COUNTIF(D1:D100,{"C","D","E"})>0)*1)=3,"C",IF(SUMPRODUCT((COUNTIF(D1:D100,{"D","E"})>0)*1)=2,"D","E")))数组公式 ...