返回

Excel专题问题求助

◆ 微信扫描二维码分享
◆ 手机QQ扫描二维码,点击右上角···分享到QQ好友或QQ空间
请拨打电话:4008017500

更多 关闭

麻烦老师们帮忙优化一下公式

lcpc_MfjLfS4n

2023-12-05 14:12:11

麻烦老师们帮忙优化一下公式,3D 数据对比的函数公式运行太大了,麻烦懂的老师帮忙优化,谢谢

=IF(AND(SUM(COUNTIF($C6:$E6,{1,2,3,5,7}))=3),"质",SUM(1,AX5))
=IF(AND(SUM(COUNTIF($C6:$E6,{1,2,3,5,7}))>1),"2 质",SUM(1,AY5))
=IF(AND(SUM(COUNTIF($C6:$E6,{0,4,6,8,9}))>1),"2 合",SUM(1,AZ5))
=IF(AND(SUM(COUNTIF($C6:$E6,{0,4,6,8,9}))=3),"合",SUM(1,BA5))

上一篇 下一篇

697

6