如何将两个条件合并成一个公式.
来源:学生作业帮 编辑:搜搜考试网作业帮 分类:综合作业 时间:2024/08/10 12:46:31
如何将两个条件合并成一个公式.
=IF(AND(FIND("叫",A1),FIND("什",A1),FIND("名",A1)),"莫再提","")
=IF(AND(FIND("我",A1),FIND("几",A1),FIND("岁",A1)),"莫再问","")
另还有就是数据假如在A~D列的话,公式要怎样修改?
没一个人会吗?
=IF(AND(FIND("叫",A1),FIND("什",A1),FIND("名",A1)),"莫再提","")
=IF(AND(FIND("我",A1),FIND("几",A1),FIND("岁",A1)),"莫再问","")
另还有就是数据假如在A~D列的话,公式要怎样修改?
没一个人会吗?
![如何将两个条件合并成一个公式.](/uploads/image/z/19673667-27-7.jpg?t=%E5%A6%82%E4%BD%95%E5%B0%86%E4%B8%A4%E4%B8%AA%E6%9D%A1%E4%BB%B6%E5%90%88%E5%B9%B6%E6%88%90%E4%B8%80%E4%B8%AA%E5%85%AC%E5%BC%8F.)
在E1输入:
=IF(AND(COUNTIF(A1:D1,"*叫*"),COUNTIF(A1:D1,"*什*"),COUNTIF(A1:D1,"*名*")),"莫再提",IF(AND(COUNTIF(A1:D1,"*我*"),COUNTIF(A1:D1,"*几*"),COUNTIF(A1:D1,"*岁*")),"莫再问",""))
下拉填充即可
=IF(AND(COUNTIF(A1:D1,"*叫*"),COUNTIF(A1:D1,"*什*"),COUNTIF(A1:D1,"*名*")),"莫再提",IF(AND(COUNTIF(A1:D1,"*我*"),COUNTIF(A1:D1,"*几*"),COUNTIF(A1:D1,"*岁*")),"莫再问",""))
下拉填充即可