以A4单元格为例=IF(A4<10000,5.5,IF(A4<100000,10.5,IF(A4<500000,15.5,IF(A4<1000000,20.5,IF(A4*0.2/10000+0.5<=200,A4*0.2/10000+0.5,200)))))
你要吗
