Excel表格中怎么在C列设置条件公式A列大于0.6，且B列等于1或2，C列反回优质？

在C2中输入或复制粘贴下列公式=IF(AND(A20.6,OR(B2=1,B2=2)),"优质",IF(AND(A20.4,A2=0.6,OR(B2=1,B2=2)),"良好",IF(AND(A2=0.4,OR(B2=3,B2=4,B2=5)),"非优良","不及格"))) 或=IF(AND(A20.6,OR(B2={1,2})),"优质",IF(AND(A20.4,A2=0.6,OR(B2={1,2})),"良好",IF(AND(A2=0.4,OR(B2={3,4,5})),"非优良","不及格"))) 下拉填充