请高手帮忙看看,excel函数用错在哪里,
来源:学生作业帮 编辑:神马作文网作业帮 分类:综合作业 时间:2024/09/29 09:33:51
请高手帮忙看看,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)))
=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))