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"})这种写法是多区间判断并返回...
Excel用IF函数怎么表达区间?答:公式为:=IF(A1>=270,"优秀",IF(A1>=260,"良好",IF(A1>=230,"中等","差")))如图所示:请点击输入图片描述 3. 可以用模糊查表公式实现同样的功能:=VLOOKUP(A1,{0,"差";230,"中等";260,"良好";270,"优秀...