excel表优良中差

答案:6 悬赏:0 手机版

解决时间 2021-12-22 02:34

提问者网友：萌卜娃娃
2021-12-21 10:33

请问=IF(BX5+BY5<10,IF(BX5+BY5>=10,IF(BX5+BY5>=30,"优"),"良"),"差")这个到底是哪里错了啊
良显示不出来啊

最佳答案

五星知识达人网友：枭雄戏美人
2021-12-21 10:47

将上述公式修改为如下公式之一=IF(BX5+BY5<10,"差",IF(BX5+BY5<20,"中",IF(BX5+BY5<30,"良","优")))
=IF(BX5+BY5>=30,"优",IF(BX5+BY5>=20,"良",IF(BX5+BY5>=10,"中","差")))
=LOOKUP(BX5+BY5,{0,10,20,30},{"差","中","良","优"})
下拉填充

全部回答

1楼网友：撞了怀
2021-12-21 14:21

改为： =IF(BX5+BY5<10,"差",IF(BX5+BY5<30,"良","优"))

2楼网友：迷人又混蛋
2021-12-21 14:01

=IF(BX5+BY5<10,"差",IF(BX5+BY5<30,"良","优"))

3楼网友：怀裏藏嬌
2021-12-21 12:42

=IF(BX5+BY5<10,"差",IF(BX5+BY5>=30,"优","良")) 改良了一下

4楼网友：山君与见山
2021-12-21 12:13

如图： e2单元格公式为： =if(d2<60,"差",if(d2<80,"中",if(d2<90,"良","优"))) 公式可向下拖。

5楼网友：狂恋
2021-12-21 12:02

应该改成=IF(BX+BY5<10,"差",IF(BX5+BY5<30,"良",IF(BX5+BY5>=30,"优")))，试一下，要搞清楚if语句执行的先后顺序

我要举报

如以上问答信息为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！

excel表 优良中差

excel表优良中差