C3=B3*IF(COUNT(FIND({"耐克","乔丹"},A3)),1/100,IF(COUNT(FIND("李宁",A3)),1/200,))
或=B3*IF(COUNT(FIND({"耐克","乔丹"},A3)),1,IF(COUNT(FIND("李宁",A3)),1/2,))%
或=B3*(SUM(COUNTIF(A3,{"耐克*","乔丹*"}))/100+COUNTIF(A3,"李宁*")/200)
或=B3*(SUM(COUNTIF(A3,{"耐克*","乔丹*"}))+COUNTIF(A3,"李宁*")/2)%
公式下拉
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024