作业帮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*
来源：学生作业帮助网 编辑：作业帮 时间：2024/04/29 01:16:13
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*
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*(1+0.0008*
公式简化如下: 如果不满足条件显示0
做了纠错处理,测试通过
=IF(AND(OR(ISNUMBER(FIND({"汽油","柴油"},$L$3))),ISNUMBER(VLOOKUP(O3,{"不锈钢",50;"碳钢",33;"铜质",53},2,))),ROUND(H8*(1+0.0012*(I8-J8)+LOOKUP($O$3,{"不锈钢","碳钢","铜质"},{50,33,53})/1000000*(J8-20)),3),0)