=IF(OR((IF(AND(D3<6,D3<>""),"不合格","合格"))<>"合格",(IF(AND(OR(E3<12.5,E3>17.5),E3<>""),"不合格","合格"))<>"合格",(IF(AND(F3>36,F3<>""),"不合格","合格"))<>"合格",(IF(AND(H3>55,H3<>""),"不合格","合格"))<>"合格",(IF(AND(OR(O3<0.95,O3>1.15),O3<>""),"不合格","合格"))<>"合格",(IF(AND(OR(P3<0.9,P3>1.9),P3<>""),"不合格","合格"))<>"合格",(IF(AND(Q3>0.01,Q3<>""),"不合格","合格"))<>"合格",(IF(AND(S3>0.1,S3<>""),"不合格","合格"))<>"合格",(IF(AND(T3<2.24,T3<>""),"不合格","合格"))<>"合格",(IF(AND(OR(V3<92,V3>96),V3<>""),"不合格","合格"))<>"合格",(IF(AND(W3<1.5,W3<>""),"不合格","合格"))<>"合格",(IF(AND(Y3<330,Y3<>""),"不合格","合格"))<>"合格",(IF(AND(Z3<91,Z3<>""),"不合格","合格"))<>"合格",(IF(AND(AA3>5000,AA3<>""),"不合格","合格"))<>"合格",(IF(AND(AB3>10,AB3<>""),"不合格","合格"))<>"合格",(IF(AND(AC3>200,AC3<>""),"不合格","合格"))<>"合格",(IF(AND(AD3>5,AD3<>""),"不合格","合格"))<>"合格",(IF(AND(AE3>50,AE3<>""),"不合格","合格"))<>"合格",(IF(AND(AF3>50,AF3<>""),"不合格","合格"))<>"合格",(IF(AND(AG3>10,AG3<>""),"不合格","合格"))<>"合格",(IF(AND(AH3>10,AH3<>""),"不合格","合格"))<>"合格",(IF(AND(AI3>25,AI3<>""),"不合格","合格"))<>"合格",(IF(AND(AJ3>50,AJ3<>""),"不合格","合格"))<>"合格",(IF(AND(AK3>10,AK3<>""),"不合格","合格"))<>"合格"),"不合格","合格")
这个函数可以怎么简化;IF函数嵌套很多层容易出错,有没有更好的函数替代它。
|