excl中怎么设置if函数条件,但条件为某一列的某一单元格值=某个值。

2025-03-17 13:42:43
推荐回答(1个)
回答1:

=if(countif(A1:A100,"X"),"正确","错误")

=if(countif(A1:A100,X),"正确","错误")