1.设置武将评分函数:
= ROUND((0.7*((A2*0.3 + B2*0.3 + C2*0.2 + D2*0.1 + E2*0.1) / 110) + 0.3*((F2*0.15 + G2*0.15 + H2*0.2 + I2*0.2 + J2*0.15 + K2*0.15) / 4) + (IF(A2>=90,1,0) + IF(B2>=90,1,0) + IF(C2>=90,1,0) + IF(D2>=90,1,0) + IF(E2>=90,1,0)) + (IF(F2=4,1,0) + IF(G2=4,1,0) + IF(H2=4,1,0) + IF(I2=4,1,0) + IF(J2=4,1,0) + IF(K2=4,1,0))) * 10, 2)
= ROUND((0.7*((A2*0.3 + B2*0.3 + C2*0.2 + D2*0.1 + E2*0.1) / 110) + 0.3*((F2*0.15 + G2*0.15 + H2*0.2 + I2*0.2 + J2*0.15 + K2*0.15) / 4) + (IF(A2>=90,1,0) + IF(B2>=90,1,0) + IF(C2>=90,1,0) + IF(D2>=90,1,0) + IF(E2>=90,1,0)) + (IF(F2=4,1,0) + IF(G2=4,1,0) + IF(H2=4,1,0) + IF(I2=4,1,0) + IF(J2=4,1,0) + IF(K2=4,1,0))) * 10, 2)