=if(B4="熟料一线脱销技改","2012JG-J-CNM04",if(B4="熟料二期脱销技改","2013JG-J-CNM10",if(B4="电气室安全监控系统","2013JG-J-CNM09",if(B4="水泥磨循环水改造","2013JG-E-CNM01",if(B4="武川水泥A磨辊压机外排风机管道改造","2013JG-E-CNM02",if(B4="二线辊压机终粉磨及粗粉循环改造","2013JG-E-CNM03",if(B4="一线辊压机终粉磨及粗粉循环改造","2013JG-E-CNM04",if(B4="一线窑头冷风套加长改造","2013JG-E-CNM05",if(B4="旧火嘴改造","2013JG-E-CNM06",if(B4="玉泉油站加防尘罩","2013JG-E-CNM07",if(B4="一线原料磨选粉机改造项目","2014JG-J-CNM01",if(B4="武川一线及玉泉自动化系统改造","2014JG-J-CNM02",if(B4="玉泉武川水泥库底电动球阀改成空气分配器","2014JG-J-CNM03",if(B4="高温风机窑头EP风机","2014JG-J-CNM04",if(B4="润滑油站检测仪表优化","2014JG-Z-CNM01",if(B4="新加辊压机","2014JG-Z-CNM02",if(B4="关于内蒙公司二线熟料库顶电缆技改项目","2014JG-E-CNM01",if(B4="布煤皮带加装通过式计量称","2014JG-E-CNM02",if(B4="武川全厂区和玉泉磨机运行监控","2014JG-E-CNM03",if(B4="玉泉及武川水泥生产监控","2014JG-E-CNM04",if(B4="挖掘机钻机矿车安装油浴式空气过滤器项目","2014JG-E-CNM05",if(B4="一二线窑尾支撑改造项目","2014JG-E-CNM06","0")))))))))))))))))))))
刚才少一个括号,加上也是不行啊