想用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),"")
既然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),"")))))
热门标签: