当年写的一个非常非常牛B的函数，到现在想想都想笑~

南墙奈

这可真是个狼灭

唯爱重生

骚噶！用牛B已经不能形容你们了

ybhc_zpl

=IF(K3="","",IF(COUNT(FIND("鞍山",K3)),"鞍山",IF(COUNT(FIND("白山",K3)),"白山",IF(COUNT(FIND("松原",K3)),"松原",IF(COUNT(FIND("延边",K3)),"延边",IF(COUNT(FIND("大连",K3)),"大连",IF(COUNT(FIND("本溪",K3)),"本溪",IF(COUNT(FIND("朝阳",K3)),"朝阳",IF(COUNT(FIND("丹东",K3)),"丹东",IF(COUNT(FIND("抚顺",K3)),"抚顺",IF(COUNT(FIND("阜新",K3)),"阜新",IF(COUNT(FIND("葫芦岛",K3)),"葫芦岛",IF(COUNT(FIND("锦州",K3)),"锦州",IF(COUNT(FIND("辽阳",K3)),"辽阳",IF(COUNT(FIND("辽源",K3)),"辽源",IF(COUNT(FIND("盘锦",K3)),"盘锦",IF(COUNT(FIND("沈阳",K3)),"沈阳",IF(COUNT(FIND("四平",K3)),"四平",IF(COUNT(FIND("铁岭",K3)),"铁岭",IF(COUNT(FIND("通化",K3)),"通化",IF(COUNT(FIND("营口",K3)),"营口",IF(COUNT(FIND("长春",K3)),"长春",IF(COUNT(FIND("吉林市",K3)),"吉林市",IF(COUNT(FIND("白城",K3)),"白城",IF(COUNT(FIND("辽宁",K3)),"沈阳",IF(COUNT(FIND({"呼和浩特","包头","乌海","赤峰","通辽","鄂尔多斯","呼伦贝尔","巴彦淖尔","乌兰察布","兴安盟","锡林郭勒","阿拉善","内蒙"},K3)),"内蒙",IF(COUNT(FIND("吉林",K3)),"四平","未识别")))))))))))))))))))))))))))

=IF(COUNT(FIND({"铁东区","铁西区","立山","千山","海城","台安","岫岩","鞍山"},L3)),"鞍山",IF(COUNT(FIND({"平山","溪湖","明山","南芬","本溪","桓仁"},L3)),"本溪",IF(COUNT(FIND({"双塔","龙城","北票","凌源","朝阳","建平","喀喇"},L3)),"朝阳",IF(COUNT(FIND({"西岗","中山","沙河口","甘井子","旅顺口","金州","瓦房店","普兰店","庄河","长海","经济技术开发区","大连"},L3)),"大连",IF(COUNT(FIND({"振兴","元宝区","振安","东港","凤城","宽甸","丹东"},L3)),"丹东",IF(COUNT(FIND({"顺城","新抚","东洲","望花","抚顺","新宾","清原"},L3)),"抚顺",IF(COUNT(FIND({"海州","新邱","太平","清河门","细河","彰武","阜新"},L3)),"阜新",IF(COUNT(FIND({"龙港","连山","南票","兴城","绥中","建昌","葫芦岛"},L3)),"葫芦岛",IF(COUNT(FIND({"太和","古塔","凌河","凌海","北镇","黑山","义县","锦州"},L3)),"锦州",IF(COUNT(FIND({"白塔","文圣","宏伟","弓长岭","太子河","灯塔","辽阳"},L3)),"辽阳",IF(COUNT(FIND({"兴隆台","双台子","大洼","盘山","盘锦"},L3)),"盘锦",IF(COUNT(FIND({"沈河","和平","大东","皇姑","铁西","苏家屯","东陵","沈北新区","于洪","新民","辽中","康平","法库","沈阳"},L3)),"沈阳",IF(COUNT(FIND({"银州","清河","调兵山","开原","西丰","昌图","铁岭"},L3)),"铁岭",IF(COUNT(FIND({"站前","西市","鲅鱼圈","老边","盖州","大石桥","营口"},L3)),"营口",IF(COUNT(FIND({"铁西区","铁东区","公主岭","双辽","梨树","伊通","四平"},L3)),"四平",IF(COUNT(FIND({"洮北","洮南","大安","镇赉","通榆","白城"},L3)),"白城",IF(COUNT(FIND({"八道江","江源","临江","抚松","靖宇","长白","白山"},L3)),"白山",IF(COUNT(FIND({"朝阳","南关","宽城","二道","绿园","双阳","德惠","九台","榆树","农安","长春"},L3)),"长春",IF(COUNT(FIND({"船营","昌邑","龙潭","丰满","蛟河","桦甸","舒兰","磐石","永吉","吉林市"},L3)),"吉林市",IF(COUNT(FIND({"龙山","西安","东丰","东辽","辽源"},L3)),"辽源",IF(COUNT(FIND({"宁江","长岭","乾安","扶余","前郭尔","松原"},L3)),"松原",IF(COUNT(FIND({"东昌","二道江","梅河口","集安","通化","辉南","柳河"},L3)),"通化",IF(COUNT(FIND({"延吉","图们","敦化","珲春","龙井","和龙","汪清","安图","延边"},L3)),"延边",IF(COUNT(FIND("吉林",L3)),"吉林省",IF(COUNT(FIND({"呼和浩特","包头","乌海","赤峰","通辽","鄂尔多斯","呼伦贝尔","巴彦淖尔","乌兰察布","兴安盟","锡林郭勒","阿拉善","内蒙"},L3)),"内蒙","未识别")))))))))))))))))))))))))

这俩公式躺在我的数据表里2年了

jake2017

厉害厉害！

天涯诗酒客

楼主:
        你这么牛B(IF大王),为何当时不申请吉尼斯?

天涯诗酒客

楼主:
        你这么牛B(IF大王),为何当时不申请吉尼斯?

7999

龙行九州 发表于 2013-9-26 09:28
MC21/MC12：

=IF(H3="铝板3",O3*L3,)&IF(H3="铝板2",O3*L3,)&IF(H3="铝型材TD34810224S",O3*L3,)&IF(H3= ...

眼镜都看了