excel多重条件函数答:公式为:=IF(LOOKUP(A2,{0,500,1000},{1,2,3})=LOOKUP(B2,{0,23,25,28},{0,1,2,3}),LOOKUP(A2,{0,500,1000},{1,2,3}),MAX(LOOKUP(B2,{0,23,25,28},{0,1,2,3}),LOOKUP(A2,{0,500,1000},{1,2,3}))/2)如图所示:请点击输入图片描述 ...
excel if 多重条件判断?答:建议参照如下:在B2单元格中输入公式:=IF(AND(A2>=6,A2<=10),0,IF(A2=5,50,IF(A2=4,60,IF(A2=3,70,IF(A2=2,80,IF(A2=1,100,IF(A2=0,200,"无效区间")))向下下拉,如图: