Question

EXCEL A列与B列其中满足条件 C列返回指定结果？

当A列或B列为合格，C列返回同意
A列和B列都不合格，C列返回返工

怎么组积公式

Answer 1

C2=if(and(a2="合格",b2="合格"),"同意","返工")。或者C2=if(countif(a2:b2,"合格")=2,"同意","返工")

Answer 2

=IF(AND(A1="合格",B1="合格"),"同意",IF(AND(A1<>"合格",B1<>"合格"),"返工",""))