EXCEL中IF函数嵌套层数怎么解决？

Question

下面是我的公式 嵌套太多了有啥办法可以优化下公式，或者用其他函数吗？？------------------------=IF(AND(OR(B2="1栋",B2="2栋",B2="3栋"),OR(I2="户内电气",I2="管道、水表及阀门",I2="燃气管道、燃具、阀门、气表")),"诚业安装",IF(AND(OR(B2="4栋",B2="5栋",B2="6栋"),OR(I2="户内电气",I2="管道、水表及阀门",I2="燃气管道、燃具、阀门、气表")),"四建安装",IF(AND(OR(B2="1栋",B2="2栋",B2="3栋"),OR(I2="墙、地面、顶棚",I2="空鼓裂纹")),"诚业总包",IF(AND(OR(B2="4栋",B2="5栋",B2="6栋"),OR(I2="墙、地面、顶棚",I2="空鼓裂纹")),"四建总包",IF(OR(I2="外墙涂料",I2="外保温"),"涂料",IF(i2="安防报警、监控","弱电",IF(I2="入户门","步阳",IF(OR(I2="防火门",COUNTIF(J2,"*防*")),"大顺昌",IF(I2="铝、塑门窗及配件","品一",IF(I2="栏杆","巧悦","错误")----------------分割线------如下面图所示 要把不同的报失分类和楼栋改成不同的施工单位

Answer 1

文件另存为后缀为.xlsx格式的文件，再嵌套