网页资讯视频图片知道文库贴吧地图采购
进入贴吧全吧搜索
excel吧 关注：280,791贴子：1,542,916
  • 17回复贴，共1页

哪位大神能帮助简化一下啊，里面的参数太多都不能运算了

f6=IF(OR(D7="上坡",D7="下坡",D7="道路变窄",D7="道路变宽",D7="连续转弯",D7="转弯",D7="十字路口",D7="T型路口",D7="Y型路口",D7="注意儿童",D7="窄桥",D7="反向弯路",D7="让行",D7="连续下坡",D7="左侧变窄",D7="右侧变窄",D7="村庄标志",D7="慢行",D7="注意落石"),"三角形",IF(OR(D7="限速10km/h",D7="解除限速10km/h",D7="限速20km/h",D7="解除限速20km/h",D7="限速5km/h",D7="解除限速5km/h",D7="限速30km/h",D7="解除限速30km/h",D7="限速60km/h",D7="解除限速60km/h",D7="限重10t",D7="限重15t",D7="危桥",D7="限宽2.35m",D7="限高3.5m",D7="黄闪",D7="限高4.2m"),"圆形"),IF(OR(D7<>"上坡",D7<>"下坡",D7<>"道路变窄",D7<>"连续转弯",D7<>"转弯",D7<>"十字路口",D7<>"T型路口",D7<>"Y型路口",D7<>"注意儿童",D7<>"反向弯路",D7<>"让行",D7<>"连续下坡",D7<>"右侧变窄",D7<>"村庄标志",D7<>"限速10km/h",D7<>"解除限速10km/h",D7<>"限速20km/h",D7<>"解除限速20km/h",D7<>"限速5km/h",D7<>"解除限速5km/h",D7<>"限速30km/h",D7<>"解除限速30km/h",D7<>"限重10t",D7<>"限重15t",D7<>"危桥",D7<>"限宽2.35m",D7<>"限高3.5m",D7<>"黄闪"),"矩形"))


自己顶一下


不是参数太多,而是括号位置没放对.
公式可以稍微简化下.
=IF(OR(D7={"上坡","下坡","道路变窄","道路变宽","连续转弯","转弯","十字路口","T型路口","Y型路口","注意儿童","窄桥","反向弯路","让行","连续下坡","左侧变窄","右侧变窄","村庄标志","慢行","注意落石"}),"三角形",IF(OR(D7={"限速10km/h","解除限速10km/h","限速20km/h","解除限速20km/h","限速5km/h","解除限速5km/h","限速30km/h","解除限速30km/h","限速60km/h","解除限速60km/h","限重10t","限重15t","危桥","限宽2.35m","限高3.5m","黄闪","限高4.2m"}),"圆形","矩形"))
另外建议做个对照表后用vlookup来完成.


谢谢谢谢


建立一個對照表，用VLOOKUP查找吧!


@zipall
=IF(OR(d7={"上坡","下坡","道路变窄","道路变宽","连续转弯","转弯","十字路口","T型路口","Y型路口","注意儿童","窄桥","反向弯路","让行","连续下坡","左侧变窄","右侧变窄","村庄标志","慢行","注意落石"}),"三角形",IF(OR(d7={"限速10km/h","解除限速10km/h","限速20km/h","解除限速20km/h","限速5km/h","解除限速5km/h","限速30km/h","解除限速30km/h","限速60km/h","解除限速60km/h","限重10t","限重15t","危桥","限宽2.35m","限高3.5m","黄闪","限高4.2m"}),"圆形"),IF(OR(d7<>{"上坡","下坡","道路变窄","连续转弯","转弯","十字路口","T型路口","Y型路口","注意儿童","反向弯路","让行","连续下坡","右侧变窄","村庄标志","限速10km/h","解除限速10km/h","限速20km/h","解除限速20km/h","限速5km/h","解除限速5km/h","限速30km/h","解除限速30km/h","限重10t","限重15t","危桥","限宽2.35m","限高3.5m","黄闪"}),"矩形"))还是不行


像这样添加辅助列，可以直接使用Vlookup


扫二维码下载贴吧客户端

下载贴吧APP
看高清直播、视频！
  • 17回复贴，共1页
分享到: