使用if函数进行多条件(每个条件都是介于2个数之间的)判断,请哪个老师帮 ...答:Excel公式表达某单元格数值介于某两个数之间,不能按上述格式输入。应当使用and函数。具体修改如下:=IF(AND(E2>=1001,E2<=1499),"A",IF(AND(E2>=1500,E2<=1999),"B",IF(AND(E2>=2000,E2<=2499),"C",IF(AND(E2>=2500,E2<=2999),"D",IF(AND(E2>=3000,E2<=4000),"E","其他"...