如果相等给出正确答案。如果不相等,取差值在百分之10以内的两组(或者三组)数据的平均值。如果三个数据的差值都大于百分之10 那么对比结果为X
=IF(COUNTIFS(A2:C2,"<="&MEDIAN(A2:C2)*1.1,A2:C2,">="&MEDIAN(A2:C2)*0.9)>1,AVERAGEIFS(A2:C2,A2:C2,">="&MEDIAN(A2:C2)*0.9,A2:C2,"<="&MEDIAN(A2:C2)*1.1),"X")
下拉