Question

EXCEL大神帮忙IF函数问题

大神帮忙看看下面的公式问题出在哪里，为什么回车时说公式错误？？

=IF(AND(COUNT($G$3:$G$69)>60,OR(G3>MAX($G$3:$G$69)-8,G3<=18)),"不参与",IF(AND(COUNT($G$3:$G$69)>40,OR(G3>MAX($G$3:$G$69)-6,G3<=12)),"不参与",IF(AND(COUNT($G$3:$G$69)>30,OR(G3>MAX($G$3:$G$69)-5,G3<=8)),"不参与",IF(AND(COUNT($G$3:$G$69)>20,OR(G3>MAX($G$3:$G$69)-5,G3<=4)),"不参与",IF(AND(COUNT($G$3:$G$69)>15,OR(G3>MAX($G$3:$G$69)-4,G3<=3)),"不参与",IF(AND(COUNT($G$3:$G$69)>10,OR(G3>MAX($G$3:$G$69)-3,G3<=2)),"不参与",IF(AND(COUNT($G$3:$G$69)>5,OR(G3>MAX($G$3:$G$69)-2,G3<=1)),"不参与","参与")))))))

Answer 1

输入
=IF(OR(AND(COUNT($G$3:$G$69)>60,OR(G3>MAX($G$3:$G$69)-8,G3<=18)),AND(COUNT($G$3:$G$69)>40,OR(G3>MAX($G$3:$G$69)-6,G3<=12)),AND(COUNT($G$3:$G$69)>30,OR(G3>MAX($G$3:$G$69)-5,G3<=8)),AND(COUNT($G$3:$G$69)>20,OR(G3>MAX($G$3:$G$69)-5,G3<=4)),AND(COUNT($G$3:$G$69)>15,OR(G3>MAX($G$3:$G$69)-4,G3<=3)),AND(COUNT($G$3:$G$69)>10,OR(G3>MAX($G$3:$G$69)-3,G3<=2)),AND(COUNT($G$3:$G$69)>5,OR(G3>MAX($G$3:$G$69)-2,G3<=1))),"不参与","参与")