Excel怎么进行多区间判断呢?答:=IF(A1<60,"F",IF(A1<70,"E",IF(A1<80,"D",IF(A1<90,"C",IF(A1<100,"B","A")))2、LOOKUP:=LOOKUP(A1,{0,60,70,80,90,100},{"F","E","D","C","B","A"})这种写法是多区间判断并返回对应值的模式化公式,是IF函数逐层判断的升级版。注意,LOOKUP第二参数要升序处...
急急急,if函数五个区间的答:公式为:=G2*IF(H2<10,1.1,IF(H2<30,2,IF(H2<50,1.9,IF(H2<70,1.7,IF(H2<100,1.6,1.5)))
EXCEL表中if函数如何表示多个区间的并列条件?答:具体函数如下:IF(AND(B2>6.9,B2<7.1),5,IF(OR(AND(B2>6.8,B2<6.9),AND(B2>7.1,B2<7.2)),4,IF(OR(AND(B2>=6.7,B2<6.8),AND(B2>7.2,B2<=7.8)),3,"输入值不在区间内!")))区间条件较多,需要借助AND,OR混合表达。and函数或者*连接。=if(and(A1>0,B1>0),或者...
如何用if语句实现给数据分段答:假设你的数据在A列,从A2开始,你可以在B2单元格输入以下公式: =IF(A2<=10,"0-10",IF(A2<=20,"10-20",IF(A2<=30,"20-30",IF(A2<=40,"30-40",IF(A2<=50,"40-50",IF(A2<=60,"50-60",IF(A2<=70,"60-70",IF(A2<=80,"70-80",IF(A2<=90,"80-90","90-100"))...
excel公式中,满足多个区间条件应该如何设公式?答:你的原始逻辑公式为:=IF((A1>=80)*(B1>=92),3000,IF(B1<86,-3000,IF((B1>=86)*(B1<92),0,"没有规定")))梳理清楚后的公式应该为:=IF(B1<86,-3000,IF(B1<92,0,IF(A1>=80,3000,"没说")))也就是:“B1大于或等于92,但A1小于80”的这个条件你没有规定!!
请教,在excel中,if函数多重区间的用法,如,>320为1级,160-320为2级,70...答:IF函数公式 =if(a1>320,"1级",if(a1>160,"2级",if(a1>70,"三级",if(a1>20,"四级","五级")))LOOKUP公式 =lookup(a1,{0,20,70,160,320},{"1级","2级","3级","4级","5级"})均可