mrlinh
幼苗
共回答了15个问题采纳率:86.7% 举报
假设这打分的三个单元格分别是A1,B1,C1,D1
E1单元格输入公式
=VLOOKUP(A1,{"A",1.2;"B",1;"C",0.8;"D",0},2,)*2+VLOOKUP(B1,{"A",1.2;"B",1;"C",0.8;"D",0},2,)*4+VLOOKUP(C1,{"A",1.2;"B",1;"C",0.8;"D",0},2,)+VLOOKUP(D1,{"A",1.2;"B",1;"C",0.8;"D",0},2,)
或
=SUMPRODUCT(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1:D1,"A",1.2),"B",1),"C",0.8),"D",0)*{2,4,1,1})
1年前
6