=IF(COUNTIF(A1:A5,"OK")=5,"PASS",IF(COUNTIF(A1:A5,"NG")>0,"FAIL",""))
=IF(COUNTIF(A1:A5,"NG")>0,"FAIL","PASS")意思是只要一个NG就FAIL。
问题补充：谢谢大家啊你们说的都对的。这么简单的我都给抛脑后了 如果数量是在A1 单价是在B1 在C1输入 =A1*B1 就行！在一个单元格内输入 =
