excel表格 or 条件值过多
发布网友
共2个回答
热心网友
OR(F2="北京市",F2="天津市",F2="石家庄市",F2="廊坊市",F2="承德市")
改成
(F2="北京市")+(F2="天津市")+(F2="石家庄市")+(F2="廊坊市")+(F2="承德市")
或者是
LOOKUP(1,0/(F2={"北京市","天津市","石家庄市","廊坊市","承德市"}))=0
以上两个公式，参照前面的城市格式在后面添加就可以了
热心网友
输入
=IF(OR(F2={"北京市","天津市","石家庄市","承德市","廊坊市","张家口市","唐山市","秦皇岛市","保定市","沧州市"}),VLOOKUP(G2,时效表!F:F,1,0),"#N/A")
