Question

关于Excel中if语句的，如果A1、B1、C1都大于30则输出"PASS"，如果A1、B1、C1任何一个小于30则输出“NG”

如果C46&F46&I46&L46都>30%则输出"测试治具精准度需改善",如果C46&F46&I46&L46都>10%而<30%则输出"测试治具精准度可以接受",如果C46&F46&I46&L46>=0%而<10%,则输出"测试治具精准度优良"

Answer 1

=IF(MIN(A1:C1)>=30,"PASS","NG")

答问题补充：
=IF(MIN(C46,F46,I46,L46)>0.3,"测试治具精准度需改善",IF(MIN(C46,F46,I46,L46)>0.1,"测试治具精准度可以接受","测试治具精准度优良"))

追问

做出来不行啊？

Answer 2

借助逻辑函数 AND 即可解决条件相与的问题。

=IF(AND(A1>=30,B1>=30,C1>=30),"PASS","NG")

Answer 3

=IF(SUMPRODUCT((A1:C1>30)*1)=3,"pass","NG")

Answer 4

=IF(A1:C1>30,"psss","ng")
这个你试试看

Answer 5

=if(A1>30,if(B1>30,if(C1>30,"pass","no"),"no"),"no")

Answer 6

=if(min(A1:C1)>30,"PASS","NG")