请高手帮忙看看,excel函数用错在哪里,
来源:学生作业帮 编辑:百度作业网作业帮 分类:综合作业 时间:2024/06/15 23:20:44
请高手帮忙看看,excel函数用错在哪里,
=SUM((IF((F2/E2)*50)>50,50,((F2/E2)*50)),(IF((H2/G2)*30)>30,30,((H2/G2)*30)),(IF((J2/I2)*20)>20,20,((J2/I2)*20)))
=SUM((IF((F2/E2)*50)>50,50,((F2/E2)*50)),(IF((H2/G2)*30)>30,30,((H2/G2)*30)),(IF((J2/I2)*20)>20,20,((J2/I2)*20)))
![请高手帮忙看看,excel函数用错在哪里,](/uploads/image/z/16379607-39-7.jpg?t=%E8%AF%B7%E9%AB%98%E6%89%8B%E5%B8%AE%E5%BF%99%E7%9C%8B%E7%9C%8B%2Cexcel%E5%87%BD%E6%95%B0%E7%94%A8%E9%94%99%E5%9C%A8%E5%93%AA%E9%87%8C%2C)
=SUM(IF(F2/E2*50>50,50,F2/E2*50),IF(H2/G2*30>30,30,H2/G2*30),IF(J2/I2*20>20,20,(J2/I2)*20))
可以简化:
=SUM(IF(F2>E2,50,F2/E2*50),IF(H2>G2,30,H2/G2*30),IF(J2>I2,20,(J2/I2)*20))
可以简化:
=SUM(IF(F2>E2,50,F2/E2*50),IF(H2>G2,30,H2/G2*30),IF(J2>I2,20,(J2/I2)*20))