AI修改得看能不能用


=ROUND(
IF(
AND(AND(E3>=80%,I3>=80%),J3>=N3),
E3*(IF($G$1="Q1",(ad3),IF($G$1="Q2",(ae3),IF($G$1="Q3",(af3),IF($G$1="Q4",(ag3),"")))),
IF(
AND(AND(E3>=60%,I3>=80%),J3>=N3),
E3*$K$1*(IF($G$1="Q1",(ad3),IF($G$1="Q2",(ae3),IF($G$1="Q3",(af3),IF($G$1="Q4",(ag3),"")))),
IF(
AND(AND(E3>=80%,I3>=80%),((H3*J3)/(G3*N3))>=$N$1),
(IF($G$1="Q1",(ad3),IF($G$1="Q2",(ae3),IF($G$1="Q3",(af3),IF($G$1="Q4",(ag3),""))))*$K$1*(H3*J3)/(G3*N3),
IF(
AND(AND(E3>=60%,I3>=80%),((H3*J3)/(G3*N3)>=$N$1),
$K$1*E3*((H3*J3)/(G3*N3))*(IF($G$1="Q1",(ad3),IF($G$1="Q2",(ae3),IF($G$1="Q3",(af3),IF($G$1="Q4",(ag3),"")))),
0
)
)
)
)
)