=IF(SUM(--((B2:B5-1621)^2>1)),IF(MAX(ABS(B2:B5-1621))=MAX(B2:B5-1621),MAX(B2:B5),MIN(B2:B5)),"合格")
使用道具 举报
=IF(AND((B2:B5-1621)^2<=1),"合格",INDEX(B2:B5,MATCH(MAX(ABS((B2:B5-1621))),ABS(B2:B5-1621),)))数组
PS:如果碰到1619和1623,该显示哪个?
本版积分规则 发表回复 回帖后跳转到最后一页
小黑屋|手机版|Archiver|Excel精英培训 ( 豫ICP备11015029号 )
GMT+8, 2024-5-15 05:52 , Processed in 0.308709 second(s), 9 queries , Gzip On, Yac On.
Powered by Discuz! X3.4
Copyright © 2001-2020, Tencent Cloud.