在B2输入以下公式，然后向下填充公式
=SUM(TEXT(A2-{0,100,200},"0;!0")*{2,0.5,0.5}%)
详见附图示例
公式为：=IF(B3<100,0.2%,IF(B3<200,0.25%,0.3%))或者是：=LOOKUP(B3,{0,100,200}*10^4,{0.2,0.25,0.3}%)
