求Excel中几组数据相减后得出绝对值最大的数值和组数据间相减得到的数...答:F1:=IF(ABS(IF(AVERAGE(MIN(B2:D2),MAX(B2:D2))>A2,MAX(B2:D2),MIN(B2:D2))-A2)>ABS(IF(AVERAGE(MIN(B4:D4),MAX(B4:D4))>A4,MAX(B4:D4),MIN(B4:D4))-A4),IF(AVERAGE(MIN(B2:D2),MAX(B2:D2))>A2,MAX(B2:D2),MIN(B2:D2))-A2,IF(AVERAGE(MIN(B4:D4),...