帮我看下这公式错在哪里:1、CR3=IF(AND(ISERROR(SEARCH(CO3,G4)),ISERROR(SEARCH(CP3,G4))),"√","×")2、CQ3=IF(ISERROR(SEARCH(CI3:CN3,S4&T4&U4)),"√","×")我的本意是:1、当CO3及CP3中的数不等于G4中的数时在CR3中打√,
来源:学生作业帮助网 编辑:作业帮 时间:2024/06/20 14:19:47
![帮我看下这公式错在哪里:1、CR3=IF(AND(ISERROR(SEARCH(CO3,G4)),ISERROR(SEARCH(CP3,G4))),](/uploads/image/z/14634106-34-6.jpg?t=%E5%B8%AE%E6%88%91%E7%9C%8B%E4%B8%8B%E8%BF%99%E5%85%AC%E5%BC%8F%E9%94%99%E5%9C%A8%E5%93%AA%E9%87%8C%EF%BC%9A1%E3%80%81CR3%3DIF%28AND%28ISERROR%28SEARCH%28CO3%2CG4%29%29%2CISERROR%28SEARCH%28CP3%2CG4%29%29%29%2C%22%E2%88%9A%22%2C%22%C3%97%22%292%E3%80%81CQ3%3DIF%28ISERROR%28SEARCH%28CI3%3ACN3%2CS4%26T4%26U4%29%29%2C%22%E2%88%9A%22%2C%22%C3%97%22%29%E6%88%91%E7%9A%84%E6%9C%AC%E6%84%8F%E6%98%AF%EF%BC%9A1%E3%80%81%E5%BD%93CO3%E5%8F%8ACP3%E4%B8%AD%E7%9A%84%E6%95%B0%E4%B8%8D%E7%AD%89%E4%BA%8EG4%E4%B8%AD%E7%9A%84%E6%95%B0%E6%97%B6%E5%9C%A8CR3%E4%B8%AD%E6%89%93%E2%88%9A%2C)
帮我看下这公式错在哪里:1、CR3=IF(AND(ISERROR(SEARCH(CO3,G4)),ISERROR(SEARCH(CP3,G4))),"√","×")2、CQ3=IF(ISERROR(SEARCH(CI3:CN3,S4&T4&U4)),"√","×")我的本意是:1、当CO3及CP3中的数不等于G4中的数时在CR3中打√,
帮我看下这公式错在哪里:1、CR3=IF(AND(ISERROR(SEARCH(CO3,G4)),ISERROR(SEARCH(CP3,G4))),"√","×")
2、CQ3=IF(ISERROR(SEARCH(CI3:CN3,S4&T4&U4)),"√","×")
我的本意是:1、当CO3及CP3中的数不等于G4中的数时在CR3中打√,否则打×,如果CO3及CP3中都有数,公式就对,但有时CO3或CP3为空时,公式就不对了,
2、类似.查找CI3:CN3中如有S4、T4、U4中的任意一个数,则在CQ3中打勾,否则打叉,问题也出在这,CI3:CN3这几个单元格中有时为空,结果就不对了!该如何解决?
请详细说明您提供的公式中每一部分的意思,我初学,不懂,
帮我看下这公式错在哪里:1、CR3=IF(AND(ISERROR(SEARCH(CO3,G4)),ISERROR(SEARCH(CP3,G4))),"√","×")2、CQ3=IF(ISERROR(SEARCH(CI3:CN3,S4&T4&U4)),"√","×")我的本意是:1、当CO3及CP3中的数不等于G4中的数时在CR3中打√,
CR3=IF(COUNTIF(CO3:CP3,G4)=0,"√","×")
CQ3=IF(COUNTIF(CI3:CN3,S4)+COUNTIF(CI3:CN3,T4)+COUNTIF(CI3:CN3,U4)=0,"×","√")