Excel中IF或lookup区间函数怎么编

Question

当X<10时 =400
当10<X<100时 =X*0.032
当100<X<1000时 =X*0.0012+0.12
当1000<X<2000时 =X*0.00084+0.48
当2000<X<4000时 =X*0.00042+0.1.32
当4000<X =30000
最好用lookup 谢谢呢

Answer 1

=lookup(x,{0,10,100,1000,2000,4000},x*{0,0.032,0.0012,0.00084,0.00042}+{400,0,0.12,0.48,0.132})