如何在excel中使用多重if函数
答案:3 悬赏:0
解决时间 2021-01-07 06:12
- 提问者网友：嘚啵嘚啵
- 2021-01-06 18:31
如何在excel中使用多重if函数
最佳答案
- 二级知识专家网友：想偏头吻你
- 2021-01-06 19:46
条件0==0,B2<=1500)，百分数上面不能带引号特别是文本引号，还有从第二个IF起都应该放在左括号的左边。追问
然后怎么修改，求正解
追答=IF(AND(B2>=0,B2<=1500),3%,IF(B2<=4500,10%,IF(B2<=9000,20%,IF(B2<=35000,25%,IF(B2<=55000,30%,IF(B2<=80000,35%,45%))))))
然后怎么修改，求正解
追答=IF(AND(B2>=0,B2<=1500),3%,IF(B2<=4500,10%,IF(B2<=9000,20%,IF(B2<=35000,25%,IF(B2<=55000,30%,IF(B2<=80000,35%,45%))))))
全部回答
- 1楼网友：大漠
- 2021-01-06 20:57
=IF(B2<=1500,"3%",IF(B2<=4500,"10%",IF(B2<=9000,"20%",IF(B2<=35000,"25%",IF(B2<=55000,"30%",IF(B2<=80000,"35%","45%"))))))
- 2楼网友：琴狂剑也妄
- 2021-01-06 20:35
=LOOKUP(B2,{0,3,9,18,70,110,160}*500,{3,10,20,25,30,35,45}%)
我要举报
如以上问答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！
大家都在看
推荐资讯