发布网友 发布时间:2024-08-19 14:29
共2个回答
热心网友 时间:2024-08-25 03:44
=IF(AND(MAX(A1,A2,A3)/MEDIAN(A1,A2,A3)>1.15,MEDIAN(A1,A2,A3)/MIN(A1,A2,A3)>1.15),"无效",IF(AND(MAX(A1,A2,A3)/MEDIAN(A1,A2,A3)<=1.15,MEDIAN(A1,A2,A3)/MIN(A1,A2,A3)<=1.15),AVERAGE(A1:A3),IF(OR(MAX(A1,A2,A3)/MEDIAN(A1,A2,A3)>1.15,MEDIAN(A1,A2,A3)/MIN(A1,A2,A3)>1.15),"中值","")))热心网友 时间:2024-08-25 03:48
=IF(AND(最大值<=中值*(1+15%),最小值>=中值*(1-15%)),average(a1:a3),if(AND(最大值>中值*(1+15%),最小值<中值*(1-15%)),"无效",中值))