30," (R2-30)*0.4*L2",IF(R2" /> 30," (R2-30)*0.4*L2",IF(R2 - 作业答案大全" />

您的位置: 首页 > 作业答案 > 其他 > 大家帮我看看这个公式问题出在哪?IF(R2>60," 30*0.4*L2+(R2-60)*0.6*L2",IF(R2>30," (R2-30)*0.4*L2",IF(R2

大家帮我看看这个公式问题出在哪?IF(R2>60," 300.4L2+(R2-60)0.6L2",IF(R2>30," (R2-30)0.4L2",IF(R2

分类: 作业答案 • 2021-12-19 16:33:44

问题描述：

大家帮我看看这个公式问题出在哪?
IF(R2>60," 30*0.4*L2+(R2-60)*0.6*L2",IF(R2>30," (R2-30)*0.4*L2",IF(R2

答

改成下面的试试：
=IF(R2>60,30*0.4*L2+(R2-60)*0.6*L2,IF(R2>30,(R2-30)*0.4*L2,0))