excel怎么计算两行变化率,两行,变化,计算

1.EXCEL表格有两行不同正负值,要用什么公式算出他们的合格率呢

5分缺乏诚意，但还是回答你吧，第一、先统计合格率，满足条件长宽高公差的视作合格，算作1，否则算为0，，第二统计工件数量，本图为20，；第三步，合格数除以工件数量=合格率，具体操作见附件，不做解释了 合格率函数代码： =（IF(AND(C1<=10,C1>=-10,C2<=5,C2>=-5),1,0)+IF(AND(D1<=10,D1>=-10,D2<=5,D2>=-5),1,0)+IF(AND(E1<=10,E1>=-10,E2<=5,E2>=-5),1,0)+IF(AND(F1<=10,F1>=-10,F2<=5,F2>=-5),1,0)+IF(AND(G1<=10,G1>=-10,G2<=5,G2>=-5),1,0)+IF(AND(H1<=10,H1>=-10,H2<=5,H2>=-5),1,0)+IF(AND(I1<=10,I1>=-10,I2<=5,I2>=-5),1,0)+IF(AND(J1<=10,J1>=-10,J2<=5,J2>=-5),1,0)+IF(AND(K1<=10,K1>=-10,K2<=5,K2>=-5),1,0)+IF(AND(L1<=10,L1>=-10,L2<=5,L2>=-5),1,0)+IF(AND(M1<=10,M1>=-10,M2<=5,M2>=-5),1,0)+IF(AND(N1<=10,N1>=-10,N2<=5,N2>=-5),1,0)+IF(AND(O1<=10,O1>=-10,O2<=5,O2>=-5),1,0)+IF(AND(P1<=10,P1>=-10,P2<=5,P2>=-5),1,0)+IF(AND(Q1<=10,Q1>=-10,Q2<=5,Q2>=-5),1,0)+IF(AND(R1<=10,R1>=-10,R2<=5,R2>=-5),1,0)+IF(AND(S1<=10,S1>=-10,S2<=5,S2>=-5),1,0)+IF(AND(T1<=10,T1>=-10,T2<=5,T2>=-5),1,0)+IF(AND(U1<=10,U1>=-10,U2<=5,U2>=-5),1,0)+IF(AND(V1<=10,V1>=-10,V2<=5,V2>=-5),1,0))/((COUNTA(C1:V2)+COUNTBLANK(C1:V2))/2)。