数量在B1，总价中输入：
=B1*IF(B1<2000,0.02,IF(B1<5000,0.015,IF(B1<6000,0.01,IF(B1<10000,0.009,0.008))))
不过在2003中只能嵌套7层，2007支持多层嵌套。
层数多时，也可以输入：
=B1*LOOKUP(B1,{0,2000,5000,6000,10000,100000},{0.02,0.015,0.01,0.09,0.08,0.07})
=B1*IF(B1<2000,0.02,IF(B1<5000,0.015,IF(B1<6000,0.01,IF(B1<10000,0.009,0.008))))
不过在2003中只能嵌套7层，2007支持多层嵌套。
层数多时，也可以输入：
=B1*LOOKUP(B1,{0,2000,5000,6000,10000,100000},{0.02,0.015,0.01,0.09,0.08,0.07})