当A1<4时IF(AND(B4>60,B4<=65),20,IF(AND(B4=60),10,IF(AND(B4>65),40,IF(AND(55<=B4,B4<60),-10,IF(AND(B4<55),-20)))))
4
当A1>4.5时 IF(AND(B6>=65),-10,IF(AND(B6<65,B6>60),-20,IF(AND(B6<=60),-30,)))
如何将这四组公式合并成一个公式？
IF条件公式合并
答案:1 悬赏:60 手机版
解决时间 2021-02-07 20:11
- 提问者网友：爱了却不能说
- 2021-02-07 15:49
当A1=4时 IF(AND(B3>60,B3<=65),10,IF(AND(B3=60),0,IF(AND(B3>65),20,IF(AND(55<=B3,B3<60),-10,IF(AND(B3<55),-20)))))
当A1<4时IF(AND(B4>60,B4<=65),20,IF(AND(B4=60),10,IF(AND(B4>65),40,IF(AND(55<=B4,B4<60),-10,IF(AND(B4<55),-20)))))
460,B5<=65),-10,IF(AND(B5=60),-20,IF(AND(B5>65),20,IF(AND(55<=B5,B5<60),-20,IF(AND(B5<55),-30)))))
当A1>4.5时 IF(AND(B6>=65),-10,IF(AND(B6<65,B6>60),-20,IF(AND(B6<=60),-30,)))
如何将这四组公式合并成一个公式？
当A1<4时IF(AND(B4>60,B4<=65),20,IF(AND(B4=60),10,IF(AND(B4>65),40,IF(AND(55<=B4,B4<60),-10,IF(AND(B4<55),-20)))))
4
当A1>4.5时 IF(AND(B6>=65),-10,IF(AND(B6<65,B6>60),-20,IF(AND(B6<=60),-30,)))
如何将这四组公式合并成一个公式？
最佳答案
- 五星知识达人网友：轻熟杀无赦
- 2021-02-07 17:07
=IF(AND(B1=60,A1=4),0,IF(AND(B1>65,A1<4),40,IF(OR(AND(B1>60,B1<=65,A1=4),AND(B1=60,A1<4)),10,IF(OR(AND(B1>65,A1=4),AND(B1>60,B1<=65,A1<4),AND(B1>65,A1>4,A1<4.5)),20,IF(OR(AND(B1<55,A1>4,A1<4.5),AND(B1<=60,A1>4.5)),-30,IF(OR(AND(55<=B1,B1<60,A1=4),AND(55<=B1,B1<60,A1<4),AND(B1>60,B1<=65,A1>4,A1<4.5),AND(B1>=65,A1>4.5)),-10,-20))))))
我要举报
如以上问答信息为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！
大家都在看
推荐资讯