如何合并这三个if函数到一个单元格里面？
答案:2 悬赏:0 手机版
解决时间 2021-03-29 13:55
- 提问者网友：几叶到寒
- 2021-03-28 23:17
如何合并这三个if函数到一个单元格里面？
最佳答案
- 五星知识达人网友：行路难
- 2021-03-28 23:43
直接改，用IF嵌套函数，最后为什么要显示为文本0呢，不显示为空？
=IF(OR(ISNUMBER(FIND({"四川","陕西","北京","天津","山西","重庆","海南","云南","甘肃","宁夏","内蒙古","贵州","山东","河北"},C2))),"二区",IF(OR(ISNUMBER(FIND({"江苏","浙江","上海","河南","安徽","福建","湖北","广东","湖南"},C2))),"一区",IF(OR(ISNUMBER(FIND({"辽宁","吉林","黑龙江"},C2))),"三区","0")))
=IF(OR(ISNUMBER(FIND({"四川","陕西","北京","天津","山西","重庆","海南","云南","甘肃","宁夏","内蒙古","贵州","山东","河北"},C2))),"二区",IF(OR(ISNUMBER(FIND({"江苏","浙江","上海","河南","安徽","福建","湖北","广东","湖南"},C2))),"一区",IF(OR(ISNUMBER(FIND({"辽宁","吉林","黑龙江"},C2))),"三区","0")))
全部回答
- 1楼网友：酒安江南
- 2021-03-29 00:18
=IF(OR(ISNUMBE…………………………………………………………"三区","0")))
我要举报
如以上回答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！
点此我要举报以上问答信息
大家都在看
推荐资讯