麻烦帮忙检查一下这个IF函数哪里有问题库存率8-12%按满分计算,每±2%扣减1分我的公式设置如下,但始终计算不准确IF(0.08>H26>0.12,"5",IF(0.12>H26>0.14,"4",IF(0.14>H26>0.16,"3",IF(0.16>H26>0.18,"2",IF(0.06>H26>0.08,

来源:学生作业帮助网 编辑:作业帮 时间:2024/11/17 02:27:13

麻烦帮忙检查一下这个IF函数哪里有问题库存率8-12%按满分计算,每±2%扣减1分我的公式设置如下,但始终计算不准确IF(0.08>H26>0.12,"5",IF(0.12>H26>0.14,"4",IF(0.14>H26>0.16,"3",IF(0.16>H26>0.18,"2",IF(0.06>H26>0.08,
麻烦帮忙检查一下这个IF函数哪里有问题
库存率8-12%按满分计算,每±2%扣减1分
我的公式设置如下,但始终计算不准确
IF(0.08>H26>0.12,"5",IF(0.12>H26>0.14,"4",IF(0.14>H26>0.16,"3",IF(0.16>H26>0.18,"2",IF(0.06>H26>0.08,"4",IF(0.04>H26>0.06,"3",IF(0.02>H26>0.04,"2")))))))

麻烦帮忙检查一下这个IF函数哪里有问题库存率8-12%按满分计算,每±2%扣减1分我的公式设置如下,但始终计算不准确IF(0.08>H26>0.12,"5",IF(0.12>H26>0.14,"4",IF(0.14>H26>0.16,"3",IF(0.16>H26>0.18,"2",IF(0.06>H26>0.08,
凡是0.08>H26>0.12这种写法的地方都修改成:H26>0.12 And H26