更新时间2019-11-19 21:40:37
=IF(W5=07,ROUND(L5*6.8716,2),IF(W5=08,ROUND(L5*6.8938,2),IF(W5=09,L5*7.0883,2),IF(W5=10,ROUND(L5*7.0726,2),IF(W5=11,ROUND(L5*7.0437,2),"")
既然W5能显示07,08。。。。,即为文本类型;
5重IF嵌套,最后的括号没匹配好。
可以修改为:
=IF(W5="07",ROUND(L5*6.8716,2),IF(W5="08",ROUND(L5*6.8938,2),IF(W5="09",L5*7.0883,2),IF(W5="10",ROUND(L5*7.0726,2),IF(W5="11",ROUND(L5*7.0437,2),"")))))