lzth.net
当前位置:首页 >> 函数IF(AND(ISNUMBER(FIND( >>

函数IF(AND(ISNUMBER(FIND(

FIND("AC",Sheet1!L2)的意思是查找AC这两个连续的字符是否在L2单元格里而你的L2是ABC,当然找不到了如果你是希望只要包含A或C就返回1,请用此公式=IF(OR(ISNUMBER(FIND({"A","C"},Sheet1!L2))),1,0)如果是希望两个字符都必须同时在L2里,那公式...

D3=IF(AND(ISNUMBER(FIND("0.8",B3)),COUNT(FIND({"低","特"},C3))),"0.8特",) 或=IF(AND(COUNT(FIND("0.8",B3)),COUNT(FIND({"低","特"},C3))),"0.8特",) 下拉

这是excel里面的公式吧? 首先FIND函数会返回查找到的位置或者错误,当查找一个单元格内包含查找的内容时,返回查找到内容的具体开始位置,如果没查找到就返回错误。 ISNUMBER测试一个字符串是否为数字,返回true或false if测试一个表达式,选择...

改成: =IF(AND(OR(ISNUMBER(FIND("US",AR3)),ISNUMBER(FIND("CA",AR3))),OR(ISNUMBER(FIND("CN",AR3)),ISNUMBER(FIND("JP",AR3)),ISNUMBER(FIND("KR",AR3)),ISNUMBER(FIND("TW",AR3))), OR(ISNUMBER(FIND("DE",AR3)),ISNUMBER(FIND("EP",AR3)))...

W2=IF(COUNT(1/FIND({"货物","贸易"},V2)),1,"") 如果你要套用ISNUMBER函数也可以: =IF(SUM(--ISNUMBER(FIND({"货物","贸易"},V2))),1,"")

=IF(or(ISNUMBER(FIND("服",A1),ISNUMBER(FIND("衫",A1)",.),.

如果Sheet1!D2单元格包函"上海"字串,则在Sheet2某单元格显示"上海",否则显示空白: 公式=IF(ISNUMBER(FIND("上海",Sheet1!D2)),"上海","")

=LOOKUP(,0/FIND({"越秀区","东山区","天河区","荔湾区","白云区","海珠区","番禺区","从化区","花都区","南沙区","增城区","黄埔区","萝岗区"},CZ2),{"越秀","东山","天河","荔湾","白云","海珠","番禺","从化","花都","南沙","增城","黄埔","...

汗,弄得那么长的公式,直接复制以下公式使用就行了: =IF(OR(E1={1;2;3;4;5;6})*ISNUMBER(FIND(E2,12345678901)),"A","X") 或者用这公式: =IF(AND(E1{1;2;3;4;5;6})+ISERR(FIND(E2,12345678901)),"X","A")

=IF(ISNUMBER(SEARCH("A*C",Sheet1!L2)),1,0)

网站首页 | 网站地图
All rights reserved Powered by www.lzth.net
copyright ©right 2010-2021。
内容来自网络,如有侵犯请联系客服。zhit325@qq.com