[已解决]这样的条件判断，如何表示？

lijian8003

=IF(YU1="错"and AGX1="错","错","")
如果YU1="错"and AGX1="错",那么显示"错",否则显示""
满足上述条件，函数如何修改？

最佳答案

月排行榜 / 总排行榜

蓝粆

2015-8-30 17:37

{:35:}

1. =IF(AND(YU1="错",AGX1="错"),"错","")

复制代码

跳转到最佳答案楼层

蓝粆

{:35:}

1. =IF(AND(YU1="错",AGX1="错"),"错","")

复制代码