发布网友 发布时间:2022-05-07 14:54
共1个回答
热心网友 时间:2022-06-30 09:43
是不是“通配符”问题? EXCEL的逻辑运算中(OR、AND等),不支持通配符,因此不能这样设计公式。可以用公式: =IF(SUM(COUNTIF(G5,"*"&{"UA","ADIDAS","COLUMBIA"}&"*")),"3VIP",IF(SUM(COUNTIF(G5,"*"&{"BR","CK","COACH","GAP","OLD-NAVY","TH"}&"*")),"VIP","非VIP"))追问就是多条件模糊求和,这个星号怎么录