求高手查看下excel 中这句if函数的错误=IF($O$3="不锈钢"*$L$3="柴油",ROUND(H8*(1+0.0008*(I8-J8)+0.00005*(J8-20)),3),IF($O$3="碳钢"*$L$3="柴油",ROUND(H8*(1+0.0008*(I8-J8)+0.000033*(J8-20)),3),IF($O$3="铜质"*$L$3="柴油",ROUND(H8
来源:学生作业帮助网 编辑:作业帮 时间:2024/05/11 18:35:32
求高手查看下excel 中这句if函数的错误=IF($O$3="不锈钢"*$L$3="柴油",ROUND(H8*(1+0.0008*(I8-J8)+0.00005*(J8-20)),3),IF($O$3="碳钢"*$L$3="柴油",ROUND(H8*(1+0.0008*(I8-J8)+0.000033*(J8-20)),3),IF($O$3="铜质"*$L$3="柴油",ROUND(H8
求高手查看下excel 中这句if函数的错误
=IF($O$3="不锈钢"*$L$3="柴油",ROUND(H8*(1+0.0008*(I8-J8)+0.00005*(J8-20)),3),IF($O$3="碳钢"*$L$3="柴油",ROUND(H8*(1+0.0008*(I8-J8)+0.000033*(J8-20)),3),IF($O$3="铜质"*$L$3="柴油",ROUND(H8*(1+0.0008*(I8-J8)+0.000053*(J8-20)),3),IF($O$3="铜质"*$L$3="汽油",ROUND(H8*(1+0.0012*(I8-J8)+0.000053*(J8-20)),3),IF($O$3="碳钢"*$L$3="汽油",ROUND(H8*(1+0.0012*(I8-J8)+0.000033*(J8-20)),3),IF($O$3="不锈钢"*$L$3="汽油",ROUND(H8*(1+0.0012*(I8-J8)+0.00005*(J8-20)),3))
)))))
求高手查看下excel 中这句if函数的错误=IF($O$3="不锈钢"*$L$3="柴油",ROUND(H8*(1+0.0008*(I8-J8)+0.00005*(J8-20)),3),IF($O$3="碳钢"*$L$3="柴油",ROUND(H8*(1+0.0008*(I8-J8)+0.000033*(J8-20)),3),IF($O$3="铜质"*$L$3="柴油",ROUND(H8
有什么问题