B1公式:=LOOKUP(A1,{0,120000,160000,200000,260000},{"","1.2%","2%","3%","4.5%"})
=lookup(a1/10000,{0,12,16,20,26},{0,1.2,2,3,4.5})*A1/100
=Lookup(a1/10000,{0,0;12,1.2;16,2;20,3;26,4.5})%*a1