EXCEL。IF函数嵌套多层

“1000>D3>=500”这种表达方式在EXCEL中是不正确的，应该表达为“AND(D3<1000,D3>=500)”
你的公式可写成：
=IF(D3<=0,0,IF(D3<500,0.2,IF(1000>D3,0.3,IF(2000>D3,0.4,IF(3000>D3,0.5,IF(4000>D3,0.6,0.7))))))

这样选择excel不能识别，我给你修正一下，按下面的公式一定可以达到你要的结果：
=IF(D3>=4000,"0.7",IF(D3>=3000,"0.6",IF(D3>=2000,"0.5",IF(D3>=1000,"0.4",IF(D3>=500,"0.3",IF(D3>0,"0.2"))))))

把公式改为：
=IF(500>D3,"0.2",IF(1000>D3,"0.3",IF(2000>D3,"0.4",IF(3000>D3,"0.5",IF(4000>D3>3000,"0.6",IF(D3>4000,"0.7"))))))
试试是你要的结果吗

2003及以前的版本最多可以嵌套7层，2007往后是64层

公式修改如下：
=IF(D3>4000,0.7,IF(D3>=3000,0.6,IF(D3>=2000,0.5,IF(D3>=1000,0.4,IF(D3>=500,0.3,IF(D3>0,0.2,""))))))