在EXCEL中,如果A1=B1=C1=D1=E1=F1="正确"的话,就显示正确,否则就显示错误,求高手指点!谢谢!

Question

意思就是说要满足A1,B1,C1,D1,E1,F1,单元格的数值都是"正确",那么才显示正确,有一个不是的话,就显示错误.请高手指点

Answer 1

=if(countif(a1:f1,"正确")=6,"正确","错误")
=IF(COUNTIF(A1:F1,"<>正确"),"错误","正确")
=IF(COUNT(1/(A1:F1<>"正确"))<6,"错误","正确")

Answer 2

=IF(AND(A1:F1="正确"),"正确","错误")
按CTRL+SHIFT+回车追问

如果是A1,C1,F1,H1,K1呢,,不是连续的,该用什么公式

追答

=IF(AND(A1="正确",C1="正确",F1="正确",H1="正确",K1="正确"),"正确","错误")

本回答被提问者采纳