简化这个=IF(AND(C3<8.5,E3="车上体"),1,IF(AND(C3>8.5,C3<13.55,E3="车上体"),1.5,IF(AND(C3>13.5,C3<17.55,E3="车上体"),3,IF(AND(C3<8.5,E3="车下体"),2.5,IF(AND(C3>8.5,C3<13.5,E3="车下体"),3,IF(AND(C3>13.5,E3="车下体"),6,IF(AND(C3<8.5,E3="车焊皮"),1,IF(AND(C3>8.5,C3<13.5,E3="车焊皮"),1.5,IF(AND(C3>13.5,E3="车焊皮"),3,IF(AND(C3<8.5,E3="切上体"),3,IF(AND(C3>8.5,C3<13.5,E3="切上体"),4,IF(AND(C3>13.5,E3="切上体"),6,""))))))))))))
|