求高手查看下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/06/30 10:54:20
![求高手查看下excel 中这句if函数的错误=IF($O$3=](/uploads/image/z/3687759-63-9.jpg?t=%E6%B1%82%E9%AB%98%E6%89%8B%E6%9F%A5%E7%9C%8B%E4%B8%8Bexcel+%E4%B8%AD%E8%BF%99%E5%8F%A5if%E5%87%BD%E6%95%B0%E7%9A%84%E9%94%99%E8%AF%AF%3DIF%28%24O%243%3D%22%E4%B8%8D%E9%94%88%E9%92%A2%22%2A%24L%243%3D%22%E6%9F%B4%E6%B2%B9%22%2CROUND%28H8%2A%281%2B0.0008%2A%28I8-J8%29%2B0.00005%2A%28J8-20%29%29%2C3%29%2CIF%28%24O%243%3D%22%E7%A2%B3%E9%92%A2%22%2A%24L%243%3D%22%E6%9F%B4%E6%B2%B9%22%2CROUND%28H8%2A%281%2B0.0008%2A%28I8-J8%29%2B0.000033%2A%28J8-20%29%29%2C3%29%2CIF%28%24O%243%3D%22%E9%93%9C%E8%B4%A8%22%2A%24L%243%3D%22%E6%9F%B4%E6%B2%B9%22%2CROUND%28H8)
求高手查看下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
有什么问题