EXCELIF函数模糊查询
A列都是产品名，⽐如衬衫，长袖衬衫，短袖衬衫，短裙，长裙搜索A列的产品名，凡是含有“衬衫”的⼀律在B列对应⾏输出“衬衫”，凡是含有“裙”字的⼀律输出“裙⼦”在B列对应⾏，请教⼀下怎么写函数，本来⽤IF函数： =IF($A8="衬衫","衬衫",IF($A8="裙","裙...
输⼊以下公式
=IF(COUNTIF(A8,"*衬衫*")>0,"衬衫",IF(COUNTIF(A8,"*裙*")>0,"裙⼦",IF(COUNTIF(A8,"*外套*")>0,"外套","其他服装")))
=IF(H2="成交词","A")
-------------------------------------------------------
=IF(COUNTIF(B2,"*费⽤*")>0,"成交词",
IF(COUNTIF(B2,"*多少钱*")>0,"成交词",
IF(COUNTIF(B2,"*价格*")>0,"成交词",
IF(COUNTIF(B2,"*怎*")>0,"询问词",
IF(COUNTIF(B2,"*仪器*")>0,"询问词",
IF(COUNTIF(B2,"*去皱*")>0,"询问词",
IF(COUNTIF(B2,"*副作⽤*")>0,"询问词",
IF(COUNTIF(B2,"*原理*")>0,"询问词",
IF(COUNTIF(B2,"*超声⼑*")>0,"询问词",
IF(COUNTIF(B2,"*除皱*")>0,"询问词",
IF(COUNTIF(B2,"*⽅法*")>0,"询问词",
countif函数怎么查重复IF(COUNTIF(B2,"*射频*")>0,"询问词",
IF(COUNTIF(B2,"*窍门*")>0,"其它",
IF(COUNTIF(B2,"*技巧*")>0,"其它",
IF(COUNTIF(B2,"*妙招*")>0,"其它","其它")))
----------------------------------------------------------------
=IF(COUNTIF(H2,"*其它*")>0,"C",
IF(COUNTIF(H2,"*成交词*")>0,"A",
IF(COUNTIF(H2,"*询问词*")>0,"B",
"D")))
-------------------------------------------------------------------
IF(COUNTIF(H2,"*超声⼑*")>0,"询问词",

版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。