“IFS(OR(B7="圆法兰",B7="模板"),BB7,OR(B7="钢板",B7="方法兰",B7="扁钢",B7="带钢",B7="镀锌扁钢"),BC7,OR(B7="矩形管",B7="方管"),BD7,OR(B7="焊管",B7="无缝管",B7="螺旋焊管",B7="不锈钢无缝管"),BF7,OR(B7="圆钢",B7="钢筋",B7="螺纹钢",B7="盘圆",B7="镀锌圆钢",B7="不锈钢圆钢"),BE7,B7="角钢",BG7,B7="不等边角钢",BH7,B7="槽钢",BI7,OR(B7="螺栓",B7="脚钉"),BN7,OR(B7="地脚螺栓",B7="全丝杆",B7="双头丝杆"),BO7,B7="方钢",BJ7,B7="H型钢",BK7,B7="美标H型钢",BL7,B7="工字钢",BM7,B7="U型螺栓(半圆)",BP7)) ”
这个公式怎么简化?
多项式化简呀~ (F12-(N12-F12*12.68%/12))-(N12-(F12-(N12-F12*12.68%/12))*12.68%/12) =(F12-N12+F12*12.68%/12) - (N12-(F12-(N12-F12*12.68%/12))*12.68%/12) =(F12-N12+F12*12.68%/12) - (N12-(F12*12.68%/12-(N12-F12*12.68%/12)*12.68%/12...