=if(A1<0,0,A1*lookup(A1,{0,3001,5001,10001},{0.5,1,1.5,2}%))
=IF(A1>10000,A1*0.02,IF(A1>5000,A1*0.015,IF(A1>3000,A1*0.01,if(A1<0,0,A1*0.005))))你试下
=if(A1<0,0,VLOOKUP(A1,{0,0.005;3001,0.01;5001,0.015;10001,0.02},2,1)*A1)
